March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
91 | |
90 | |
85 | |
73 | |
49 |
User | Count |
---|---|
167 | |
147 | |
92 | |
70 | |
58 |