Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sabilahmed
Resolver I
Resolver I

Mapping Visual - Select all slicer not showing RAG buckets separately

Hi all,

 

This is wierd situation i'm facing. When I select all in the buckets slicer below it mixes all the RAG colours showing all items together as the same colour. Instead what I want to see are all the RAG colours separately on the map

sabilahmed_0-1675954534429.png

In the bubble colour section (fx) I add a measure:

Color = 
VAR _OriginColor  = SELECTEDVALUE('Origin Count Buckets'[Buckets_Description])
VAR _Return = SWITCH( TRUE(), _OriginColor = "Green","#6AA84F",
                            _OriginColor = "Orange","#E69138",
                            _OriginColor = "Yellow", "#F1C232",
                            _OriginColor = "Red", "#CC0000",[Mile Category])
RETURN _Return


Here is the model relatipships, I have highlighted the Origin Count Buckets table used in the measure above:

sabilahmed_1-1675954832574.png

Any ideas?

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.