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
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou