Sort Legends

[spathak04]

Hello,
I have this shape Map visual with color saturation based on category that I have created via calculated column. (Please see the image below).
But my legends which is my category are not in order or sorted in Descending/Ascending order. 
I want the order like 100% or more, 75-100%, 50-75%, 25-50%, less than 25%.

[TomMartens · Accepted solution]

Hey,

to provide a defined order to column values you have to create an additional column "sort column" that just contains a simple integer value. You have to make sure that for example for each value of "100% and more" the value in the new column equals 1 ...

This is described in this article:

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

Hopefully, this is what you are looking for.

If the article doesn't help to solve your requirement, please provide a pbix file with sample data, upload the file to onedrive or dropbox and share the link.

Regards,

Tom 

[spathak04]

Thank you so much for quick reply. I tried using creating sort order column but I dont see any sorting option from three dots on top right corner of Map visual.(Please see the image below)

[TomMartens]

Hey,

the sort order column is applied in the data model and described in the article, please read the article. 

Regards,

Tom

[spathak04]

Thanks for the help. I got one error initially(Please see image 1). But I know the solution for that. I create one column using query editor. It solved the issue. 

Thank you for your help again.

[TomMartens]

Perfect!

[TomMartens]

Hey,

please excuse, I just realized that the document has been changed - I'm sorry about that.

Please search for this section in the document;

Sort using the Sort by Column button

Regards,

Tom