Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Map Highlight bubbles

Hi ! I am trying to see some information in the Map visual tool. Im relating to tables because I have the info in 2 different tables, One for the Installbase and one for the Headcounts. At the same ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    You can hightlight your bubbles by adding measure into data color.

    I build a sample table:

    Build two slicer tables without building relationships between them and this table.

    Channel = VALUES('Table'[Channel])
    Role = VALUES('Table'[One])

    Measure:

    HighlightColor = 
    VAR _SelChannel =
        SELECTEDVALUE ( Channel[Channel] )
    VAR _SelRole =
        SELECTEDVALUE ( Role[One] )
    RETURN
        IF (
            ISFILTERED ( Channel[Channel] ) && ISFILTERED ( Role[One] )
                && _SelRole = MAX ( 'Table'[One] )
                && _SelChannel = MAX ( 'Table'[Channel] ),
            1,
            IF (
                ISFILTERED ( Channel[Channel] )
                    && _SelChannel = MAX ( 'Table'[Channel] )
                    && _SelRole = BLANK (),
                1,
                IF (
                    ISFILTERED ( Role[One] )
                        && _SelRole = MAX ( 'Table'[One] )
                        && _SelChannel = BLANK (),
                    1,
                    0
                )
            )
        )

     Add this measure into the  data color .

    Result is as below, bubbles in map will show black by default and will be highlighted in blue when you select slicer.

    You can download the pbix file from this link: Map Highlight bubbles

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.