Stacked bar chart Single

[vjnvinod]

hi All.

here is my KPI with a single line stacked chart below, is there any better way i can have a stacked represented in betterway, as its height needs to be fixed, when i use various slicers in the dashboard.

some kind of workaround which will make this look good, 

[Ritaf1983 · Accepted solution]

Hi @vjnvinod 

When it comes to combining cards with visualizations, it's true that cards aren't responsive enough to guarantee proportions won't shift when data changes. Additionally, reading and interpreting cards designed this way can be quite challenging for users.

While it's common to associate KPIs with cards, this practice doesn't always serve the data's purpose. Cards like these tend to:

Scatter information across multiple areas, making it harder for the brain to process.
Use horizontal bars that are difficult to compare at a glance.
Repeat the same data points in multiple locations.
Rely heavily on colors, requiring extra cognitive effort to decode their meaning.
As an alternative, you could design a combined chart within a table, similar to the example in the attached image.

Here are a few guiding principles:

Use charts only where comparisons are needed, not just to display numbers.
Highlight issues or areas needing improvement; data points that are "on track" don't need extra visual emphasis.
Avoid repeating the same data unnecessarily.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

From here, feel free to adapt the example to match your specific business scenario—it's a flexible starting point! Let me know if this resonates or if I missed any key considerations in your context.

The pbix is attached