Forum Discussion
Duplicating Map Legend
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:
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:
Postcode | County | Client | Customer Code | Establishment Type | Establishment Phase | |
M29 8BS | Manchester | Yes | CAM01 | Other Independent | Secondary | |
M29 8BS | Manchester | No |
| Other Independent | Primary | |
M29 8BS | Manchester | No |
| Other Independent | Secondary | |
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 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],", ")
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
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:
Sean! Thank you ever so much, I would be so lost without you :catlol:
This has worked for me!!
Thank you again!
Francesca