Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Map legend help

I have created a map from 13 locations. I have 2 problems: 1. The legend lists the item numbers as 1, 10, 11, 12, 2, 3, 4, etc. - how do I get them in numerical order? 2. How do I get the location ...
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Is this problem sloved? 

    If it is sloved, could you kindly accept it as a solution to close this case?

    If not, please let me know.

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

1.

First change the data type of the legend column to "whole number", then it should sort as expected.

If not, please could find some useful solutions here:

https://community.powerbi.com/t5/Desktop/Modify-the-legend-order/td-p/25337

 

2. As tested, i can only show "Location" field information on the map points.

When you hover over the points, you can see legend information on the tooltips.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Maggie - how do you change the data type?  

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Click on the column, then select "Modeling"->date type/date format

    https://docs.microsoft.com/en-us/power-bi/desktop-data-types

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.