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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.