Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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%.
Solved! Go to 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
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;
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |