Forum Discussion

Alisea_MI's avatar
Alisea_MI
Resolver II
5 years ago
Solved

Manually sort 100% stack bar chart

Hi,   I would need to sort my 100% stack bar chart so that the category below "LTA25" comes on top of the list. My target order is: LTA25, 26-34, 35-44, 45-54, 55-64, 65+.   Would really...
Need Help
  • Alisea_MI's avatar
    Alisea_MI
    5 years ago

    Thank you, everyone! All these solutions would work fine. However, I missed to mention that I have a direct query and limited possibility to sort, but I have got help to find a workaround that worked in the report mode. 

     

    I put age in the tooptip and set it to min, and it did the trick.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

For a custom sort order, go to Power Query > Add Conditional Column. Populate the pop-up menu selecting the column where your range values are similarly like this:

Then, Close & Apply. Go to the Data View. Select the Range Values column, look for the Sort By Column Option in the top menu and select Sort By Sorting_Column.

That will do it. Just ensure that your visual is sorted by the range values column.