Forum Discussion
Clustered stacked chart possible?
Hi
is it possible to create a clustered stacked chart with a native Power BI visual?
I need to create something like this, whereby the left blue stacked bar represents group A and the right yellow/orange stacked bar represents group B.
If not possible, what would be another way to visualize this?
Regards
Ron
Main issue with your .pbix: Chart type is wrong and also we cannot use the same for both grouping and legend.
Additional details below to modify ...
1. Change the chart type stacked column chart
2. Change these and to use "Grouping"
3. Adjust these settings
Drill down to lowest level:
Final output will be like below:
Hope this helps!
5 Replies
sevenhillsSuper User
You cannot get the same like your output chart with native Power BI charts.
Optional: But can tryout this if you are ok:
1. Add this calculated column:
Stacked Grp = SWITCH( TRUE() , Table1[Business Card] in { "Maestro Deibt", "Visa Debit", "Mastercard Debit" }, 1, 2)2. Use this Stacked Grp in X-axis
3. Output will be like this (I used my data as Month name, Stacked Grp as 1, 2 values)
Hi sevenhills
Yhnx for your reaction.
I don't exactly get it working as you describe.
Maybe you can check the attached pbix and make the necessary changes?
Grouping-pbix
Regards
Ron- sevenhills
Main issue with your .pbix: Chart type is wrong and also we cannot use the same for both grouping and legend.
Additional details below to modify ...
1. Change the chart type stacked column chart
2. Change these and to use "Grouping"
3. Adjust these settings
Drill down to lowest level:
Final output will be like below:
Hope this helps!
Works.
Thnx sevenhills- sevenhills
Glad to hear it works!
------------------------------------------
Appreciate your Kudos 👍