Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Legend category in Map

Hi All, I have a map visual having a 3 level drilldown. State --> Station -->Meter ID. The map essentially shows malfuctioning meters. The below is my map table structure :  ID State Sta...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thank You for your Answers.

     

    I actually found a work around which fits my requirement. If we are willing to let go of the ability to click on the legend , We can format the icon color of the map by using the conditional formatting option shown below.

     

    For the legend, We will have to make do with an image or formatted table as shown below:

     

MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

What is the exact purpose you need to do.

 

Using the disconnected table you should do something similar to:

MissingreadsBucket =
VAR Summary =
    SUMMARIZE (
        MM_LocationData,
        MM_LocationData[ID],
        MM_LocationData[IsMeterMissingRead]
    )
RETURN
    SWITCH (
        SELECTEDVALUE ( LEGENDTABLE[ID] ),
        1, COUNTROWS ( FILTER ( Summary, MM_LocationData[IsMeterMissingRead] >= 0.1 ) ),
        2, COUNTROWS ( FILTER ( Summary, MM_LocationData[IsMeterMissingRead] < 0.1 ) )
    )

This is only making the count of the rows nothing more.

 

Can you please tell me what is the result you are trying to achieve.

 

If you could please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.