Map legend help

[SSpeer]

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 number to show up within the circle on the map?

Thanks.

[v-juanli-msft · Accepted solution]

Hi @SSpeer 

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]

Hi @SSpeer 

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.

[SSpeer]

Maggie - how do you change the data type?  

[v-juanli-msft]

Hi @SSpeer 

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.