Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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!
Glad to hear it works!
------------------------------------------
Appreciate your Kudos 👍
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
109 | |
89 | |
76 | |
67 |
User | Count |
---|---|
125 | |
111 | |
100 | |
83 | |
71 |