Forum Discussion

rchen's avatar
rchen
New Member
10 years ago
Solved

Labels on Maps

Hi, 

 

I am creating a map view that has fields like address, store number, store name, sales, sales/week/store.

Now I can use address as location, sales as Bar Height. How can I add the store number and store name, so the label  for each location has store number and store name?

Thank you!

 

Rchen

  • Hi rchen,

     

    Based on my understanding, you are using the GlobeMap visual to create a report, right?

     

    In your scenario, please create a custom column using the DAX expression like below:

     

    Column = [Address] & " " & [Store number] & " "& [Store name]

     

    Then place this column as Location in a GlobeMap.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

4 Replies

  • I think the new Customizable Tooltips feature is the solution for you. I am not sure if you can only add measures as tooltips, but then you can calculate measures that will return your text values.

     

    You can read about it here

    • rchen's avatar
      rchen
      New Member

      I set the store number as Do Not Summarize. When I put the store number in the tooltips, it will calculate and has no option to set as Do Not Summarize.

      I just need the store number shown as Text for each loaction.

       

      Thanks

      RChen

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support

    Hi rchen,

     

    Based on my understanding, you are using the GlobeMap visual to create a report, right?

     

    In your scenario, please create a custom column using the DAX expression like below:

     

    Column = [Address] & " " & [Store number] & " "& [Store name]

     

    Then place this column as Location in a GlobeMap.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

    • rchen's avatar
      rchen
      New Member

      Thank you Qiuyun_Yu!

       

      I put the new column using the DAX as location , but some of stores are not showing up on the map.

       

      RChen