Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I'm trying to sort the legend by a custom order and looked at past tutorials to create the sort table and sort index.
But when I try to sort the legend for the stacked chart, it still sorts the legend by alphabetical order.
Am I missing a step somewhere?
Sample data and the stacked chart:
Relationships between the tables:
Table sorted by column sort order:
Solved! Go to Solution.
Hi @Gerri ,
Add the sort order column to tooltip field, then you should be able to sort the visual by that column.
Best Regards,
Jay
Hi @Gerri ,
Add the sort order column to tooltip field, then you should be able to sort the visual by that column.
Best Regards,
Jay
Sorted! Thanks for your help!
Hi @Gerri
You need to use the feature of SORT BY COLUMN, pls see below image
Thanks & Regards,
Mohammed Adnan
Learn Power BI: https://www.youtube.com/c/taik18
Hi @Gerri
Can you try to select ascending/descending in the legend of this visual
Thanks & Regards,
Mohammed Adnan
Learn Power BI: https://www.youtube.com/c/taik18
Hi @mohammedadnant ,
With the legend of this visual selected:
With the legend of this visual not selected:
The strange thing is that I have no problems with the legend if it was a pie chart..
Hi @mohammedadnant ,
Is there any solution for the visual to sort by the custom sort order? I've tried rebuilding my visual but the legend won't sort by the custom order if it's a column chart..
Hi @Gerri
Please share the sample to test.
Thanks & Regards,
Mohammed Adnan
User | Count |
---|---|
141 | |
70 | |
69 | |
52 | |
52 |
User | Count |
---|---|
209 | |
92 | |
64 | |
60 | |
57 |