Switch the order of Legend

[Anonymous]

Hi Experts,

I am trying to switch the order of categories in "Legend"

Now its reading like this,

I was wondering if I could switch the order of extreme - low so that it reads extreme, high, moderate and low.

Thanks for your help in advance.

Regards

[jdbuchanan71]

Hello @Anonymous 

You will need a column in your data that tells PowerBI how to sort the [Current Status].  Take a look at this article about how it works.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

Hi @jdbuchanan71 ,

Thanks for your response. i tried that option earlier. But I can see only this,

i just want to switch the order of legend cateogies.

Thanks

[jdbuchanan71 · Accepted solution]

Take a look at that article.  You will have to add a column to your data model that contains the numeric sort order you want your status field to sort by.

[Anonymous]

I just had a look few times. I dont see anywhere it states that , add a column to data model that contains the numeric sort order.

Sorry, pls let me know if I am missing anything.

Thanks

[jdbuchanan71]

@Anonymous 

Take a look at this thread which discusses the same topic.  My more detailed description there should help.

https://community.powerbi.com/t5/Desktop/Sort-Slicer-Value-By-A-Different-Column/m-p/715630