Forum Discussion
Map Highlight bubbles
- Anonymous5 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.
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.
I cant download you powerbi file !
beside that didnt work when i selelct the year per exemple it shown me only the filtred bubbles on the map !