cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to sort a stacked column chart based on rank by total of what's in the 'Column Series'?

Hi all,

 

I'm having a bit of trouble here with something that seems like it would be so simple. I have a verticle stacked bar chart with the Month name in the 'Shared Axis', the Product Family Name in the 'column series' (which is what is being stacked), and the Total in the values.

 

Right now, it is showing an ugly Stacked Bar chart with a lot of the smaller values at the bottom of the chart, whereas the larger amounts are spread randomly in middle. How can I make a ranking of each of the Product family names based on the total per Product Family name? I don't know whether I should use a Measure or a Calculated column.

 

A calculated column seems like it'd be easier because I could 'Sort by" the rank if it's there, but I don't know how to do that. I've seen other people online make a measure like this, which is what I tried: 

FamilyRank = Rankx(All(dimProgram[Family]), [Total FTEs], ,1)
 
This measure would work on a simple table if I wanted to sort by it, but it does not work for a Stacked Column Chart. I'm not exactly sure where to go from here. Here is what the chart currently looks like: 
 
rzgazaryan_0-1620079614812.png

 

I would appreciate any here here. Thank you!

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,

 

I have answered in other similar posts, you can refer to

Data order in visualisation

 

Replace the clustered column chart with the stacked column chart

111.png

 

 

 

Best Regards,

Stephen Tao

 

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

View solution in original post

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

Hi @Anonymous ,

 

I have answered in other similar posts, you can refer to

Data order in visualisation

 

Replace the clustered column chart with the stacked column chart

111.png

 

 

 

Best Regards,

Stephen Tao

 

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

View solution in original post

Anonymous
Not applicable

This is incredible. Thank you.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!