Enhancement Request: Support Dynamic KPI Visuals Split by Dimension (Similar to Tableau KPI Panels)

[Teodora]

Summary

Currently, Amazon QuickSight KPI visuals support displaying only a single aggregated value per visual. This limits the ability to create dynamic KPI panels that automatically adapt to the number of categories in a dimension.

In tools such as Tableau, it is possible to create KPI visuals that are split by a dimension, dynamically rendering multiple KPI values within the same visual depending on the dimension’s cardinality. This capability is particularly useful for executive dashboards and operational monitoring use cases.

This enhancement request proposes adding support for dynamic, dimension‑driven KPI visuals in QuickSight .

Comparison

Tableau Behavior

In Tableau, KPI visuals can be split by a dimension field (for example, Cycle). When this is done:

• The KPI visual dynamically displays one KPI per distinct dimension value

• The number of KPIs adjusts automatically (e.g., 3 cycles, 10 cycles, etc.)

• The layout adapts to fit all values

• Each KPI can be aligned with a corresponding trend view, also split by the same dimension

Example:

1. KPI Panel

   • Cycle 1 → KPI value

   • Cycle 2 → KPI value

   • Cycle 3 → KPI value

2. Trend Panel

   • Line or bar trends split by the same Cycle dimension

This allows users to quickly compare performance across categories while maintaining visual consistency.

Current QuickSight Limitation

In Amazon QuickSight:

• KPI visuals support only a single value

• Dimensions cannot be used to dynamically split KPI output

• Users must duplicate KPI visuals manually for each category

• Dashboards become static, harder to maintain, and less scalable when new dimension values are introduced

Proposed Enhancement

Split KPI by Dimension

• Allow a dimension field to be added to a KPI visual

• Render one KPI value per dimension value dynamically

Example:

In Tableau there is the option to create a KPI chart split by dimension. For example, here we have two charts:

1. KPIs

2. Trends

In Tableau the KPI chart can be dynamic. If the chart is split by the “Cycle” field, it will show as many cycles as it has - they can be 3 or 10. Also the chart is fitting all possible values. The second chart is the same but we show a trend split again by “Cycle” Field.

In QuickSight we can create only KPIs with one value:

Thank you for considering this enhancement. Could you advice if this is possible?

Kind regards,

Teodora

[WLS-Cesar]

Hi @Teodora,

Thanks for bringing this up! This is a well-documented gap between Tableau and QuickSight. You’re not the first to raise this; there was a similar request back in October 2025 asking for the same capability. Unfortunately, native dimension-split KPI visuals are not currently supported in QuickSight.

That said, here are a few workarounds that may help depending on your use case:

1. Highcharts Custom Visual (Bullet Charts)

The accepted answer on that earlier post suggests using Highcharts bullet charts, they dynamically render one KPI per dimension value and auto-label via the X-axis. See this blog post for setup details. This is probably the closest to Tableau’s behavior.

2. Pivot Table with Conditional Formatting (Best Scalability)

Use a pivot table with your dimension (e.g., Cycle) as rows and your KPI measure as the value. Then apply:

• Conditional formatting with color scales or icon sets to mimic KPI status indicators

• Progress bars on the metric column for a more visual feel

This scales automatically, new dimension values appear without any dashboard changes. It’s not as visually compact as Tableau’s KPI cards, but it’s fully dynamic.

Hope this helps and feel free to follow-up with any additional questions!

[Teodora]

Hi @WLS-Cesar, thank you for the proposal! Currently, we use the pivot table with conditional formatting. What we want to achieve also is a conditional formatting for each separate KPI.

Is it possible to set up different thresholds for each KPI?

Thank you in advance!

Teodora

[WLS-Luis]

Hi @Teodora,

You can set up different thresholds by going into Visual Properties for your respective KPI(s) and clicking on the Conditional Formatting option (example shown below). This will allow you to format based on the comparison or actual value, and then you can add a text color/icon based on whatever condition(s) you would like to add!

Please let me know if this answered your question and/or if you have any other further questions involving conditional formatting!