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:

     

teatree's avatar
teatree
Frequent Visitor
9 years ago

My client column has both Yes/No

 

Are you saying it would be better if these were split into separate columns? Because by doing what you have said, everything is the same colour and everything in that client column shows up as 1, whether it says yes or no

 

Thanks for your help by the way:)

Sean's avatar
Sean
Community Champion
9 years ago

teatree Okay you still need to drag Client to the size!

However the issue I think is happening and/or will happen inevitably at different levels when you do the drill down.

It will definitely happen when you are on the county level.

EDIT: Because you are plotting 1 County (1 Location) that has both Customers and Not Customers.

So the drill-down will work but only on the levels where each point you plot can be only either Customer or Not Customer.

If it can be both you'll get your original result.

There are many ways you can go about resolving this.

1) Use several maps - each at a different level. So we you click a County on one the other will zoom in on the zipcode

2) Plot only zipcodes and put all else in the tooltips (you'll need measures to do this) and use Slicers to navigate the Map

 

 

Hope this helps! :smileyhappy:

 

Let me know if you have any questions.

  • teatree's avatar
    teatree
    Frequent Visitor
    9 years ago

    Sure, here it is

     

     

    • 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?