Forum Discussion
Sort Legends
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
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
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)
Hey,
the sort order column is applied in the data model and described in the article, please read the article.
Regards,
Tom
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.Perfect!
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