Forum Discussion
Multi Dimension Sorting in a clustered column chart
I have a clustered column chart where on the x-axis I have a time dimension [in this case FY Year and Quarter]. On the legend I have DimOrg[Organization State]. I'm filtering out the top 3 States per each FY Year Quarter using a measure titled [Rank Spend by Org State].
The issue is that I would like to sort by in the Clustered Column Chart FY Year Quarter descending and w/i FY Year Quarter sort by ranking of totla spend for the state. I've searched the forum for a couple of days and figure I needed to ask. I have a sample file attached. As output I essentially like for would like columns under FY2021 Q1 to be sorted by total spend in descending order within that Year Quarter. Picture of dashboard below, link below.
https://drive.google.com/drive/folders/1V91FntSmy33fDwO2SHSIVe1xdBryQb-b?usp=sharing
Your help is much appreciated!
5 Replies
- amitchandak
Super User
Anonymous , I do not have access to file. I doubt that is possible. But let me check out on my data.
- amitchandak
Anonymous , In clustered column chart the second sort is on the legend. I checked and I do not see any option.
This article shows that legend name is the second sort.
https://www.seerinteractive.com/blog/reorder-powerbi-legend/
There are few ideas on that
https://ideas.powerbi.com/ideas/search-ideas/?q=sort%20in%20clustered%20column
