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

Hi Alisea_MI 

You can add a column to sort your category . In Query Editor , add a conditional column like this :

Then in desktop view , add a 100% stack bar chart visual , in Axis ,add category and custom column .Sort by Custom and column 1 , in ascending order .

The final result is as shown :

I have attached my pbix file ,you can refer to it .

 

Best Regards

Community Support Team _ Ailsa Tao

 

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