Forum Discussion

teatree's avatar
teatree
Frequent Visitor
9 years ago
Solved

Duplicating Map Legend

Hi,   My map seems to be duplicating each point on the map when both of my legends are selected.   So, I'm placing a pointer on a map to say that one is a client and the other is not a client. Wh...
  • Sean's avatar
    Sean
    9 years ago

    You are welcome! :smileyhappy:

    One more thing you may consider is concatenating columns into a new column solely for Tooltip Use.

    So first create a Column by concatenating the information you want to show in the Tooltip and then use this new column in a Measure!

    Hope this helps! :smileyhappy:

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi teatree,

Agree with Sean. Tooltips in Power BI Desktop are an effective way of providing more contextual information and detail to data points on a visual, please drag countrymeasure and EstablishMeasure into Tooltips of Map visual  according to Sean’s reply. I make a test using your sample data, for more details, you can review the attached PBIX file.

CountryMeasure = VALUES(Table1[Country ])
EstablishMeasure = VALUES(Table1[Establishment Name])



Moreover, with the slicers in the above screenshot, you are able to filter your map based on needs.

Thanks,
Lydia Zhang



teatree's avatar
teatree
Frequent Visitor
9 years ago

Hi Lydia,

 

Your map is exactly what I'm looking to do. I've downloaded the file and have had a look at it but when I try to apply to my data, I get an error:

 

MdxScript(Model) (1, 43) Calculation error in measure 'Table1[EstablishmentNameMeasure]: A table of multiple values was supplied where a single value was expected.

 

I completely understand what you are doing and it is what I need to apply to my data. 

 

Do you know what I'm doing wrong?

 

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    teatree Did you try the Measure (underlined in red) in the first picture (top left corner) from my Last Resposne?

     

    Establishments = CONCATENATEX ( VALUES('TableName'[Establishment Name]), 'TableName'[Establishment Name],", ")

     

     

  • teatree's avatar
    teatree
    Frequent Visitor
    9 years ago

    Hi Sean,

     

     

    Sorry, I missed your post! This seems to actually be working v well for me. Let me keep playing with it and make sure that this is indeed what I need. Thank you so much :)

     

    Francesca

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    You are welcome! :smileyhappy:

    One more thing you may consider is concatenating columns into a new column solely for Tooltip Use.

    So first create a Column by concatenating the information you want to show in the Tooltip and then use this new column in a Measure!

    Hope this helps! :smileyhappy:

     

  • teatree's avatar
    teatree
    Frequent Visitor
    9 years ago

    I assume this is because from the data clip that you used, every value was unique. 

     

    I have several county's/postcode's which are the same.. 

     

    So an establishment can be in the same location as another but will have a different name. I'm mainly using this for schools so for example:

     

    The postcode: M29 8BS has 4+ records assigned against it:

     

    Establishment Name

    Postcode

    County

    Client

    Customer Code

    Establishment Type

    Establishment Phase

    Cambian 110 Peelhouse

     M29 8BS

    Manchester

    Yes

    CAM01

    Other Independent

    Secondary

    Cambian Meadow Road

     M29 8BS

    Manchester

    No

     

    Other Independent

    Primary

    Cambian Tyldesley School

     M29 8BS

    Manchester

    No

     

    Other Independent

    Secondary

    Cambian Willoughby School

     M29 8BS

    Manchester

    Yes

    CAM02

    Other Independent

    Primary

     

    I'm assuming this is why I'm getting the error when placing the measure in tooltips? 

     

    Francesca

  • teatree's avatar
    teatree
    Frequent Visitor
    9 years ago

    Sean! Thank you ever so much, I would be so lost without you :catlol:

     

    This has worked for me!!

     

    Thank you again!

    Francesca