Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Sort legend for stacked column chart

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:

Anonymous
4 years ago
Hi Anonymous ,

Add the sort order column to tooltip field, then you should be able to sort the visual by that column.

Best Regards,

Jay

8 Replies

mohammedadnant
Impactful Individual
4 years ago
Hi Anonymous

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
- Anonymous
  Not applicable
  4 years ago
  Hi mohammedadnant ,
  I did use SORT BY COLUMN but it doesn't affect the visual.
  - mohammedadnant
    Impactful Individual
    4 years ago
    Hi Anonymous
    
    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
Anonymous
Not applicable
4 years ago
Hi Anonymous ,

Add the sort order column to tooltip field, then you should be able to sort the visual by that column.

Best Regards,

Jay
- Anonymous
  Not applicable
  4 years ago
  Sorted! Thanks for your help!

Related content