Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
PowerRon
Post Patron
Post Patron

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.

Knipsel.JPG

If not possible, what would be another way to visualize this?

Regards
Ron

 

 

1 ACCEPTED 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

sevenhills_2-1714330381247.png

 

 

2. Change these and to use "Grouping" 

 

sevenhills_3-1714330412824.png

 

3. Adjust these settings

sevenhills_0-1714330206447.png

 

sevenhills_1-1714330347306.png

Drill down to lowest level:

sevenhills_5-1714330566754.png

 

 

Final output will be like below:

sevenhills_4-1714330488443.png

 

Hope this helps!

View solution in original post

5 REPLIES 5
PowerRon
Post Patron
Post Patron

Works.
Thnx @sevenhills 

Glad to hear it works!

 

------------------------------------------

Appreciate your Kudos 👍

sevenhills
Super User
Super 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)

sevenhills_0-1714168513559.png

 

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

sevenhills_2-1714330381247.png

 

 

2. Change these and to use "Grouping" 

 

sevenhills_3-1714330412824.png

 

3. Adjust these settings

sevenhills_0-1714330206447.png

 

sevenhills_1-1714330347306.png

Drill down to lowest level:

sevenhills_5-1714330566754.png

 

 

Final output will be like below:

sevenhills_4-1714330488443.png

 

Hope this helps!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.