Conditional Formatting Not Getting Applied on all Cells In matrix

[Anonymous]

Hi Team 

I have Created a Measure to Apply  Conditional Formatting According to Quartile But It is not Working On all Values.

across_colour = var quartile = SELECTEDVALUE('Dax Groupby'[RAP_Quartile_accross])

return

SWITCH(true(), quartile = "Q1" ,"#A0FE93", quartile = "Q2","#E7FAAC",quartile = "Q3","#E66C37",quartile = "Q4", "#FE9393")

within_colour = var quartile = SELECTEDVALUE('Dax Groupby'[RAP_Quartiles_within])

return

SWITCH(true(), quartile = "Q1" ,"#A0FE93", quartile = "Q2","#E7FAAC",quartile = "Q3","#E66C37",quartile = "Q4","#FE9393")

Attaching Screenshot for your reference.

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download sample PBIX file

Try this, it works for me with my sample data

CF = 

SWITCH(
    
    MIN('Data'[Quartile]),
    
    "Q1" ,"#A0FE93", 
    
    "Q2","#E7FAAC",
    
    "Q3","#E66C37",
    
    "#FE9393"
)

Regards

Phil

[Anonymous]

Thanks Phil 

It Works 

Can You Please elaborate why did earlier dax didn't work and this one does

[PhilipTreacy]

Hi @Anonymous 

I can't say for sure without your data but I'd say SELECTEDVALUE wasn't returning what you thought it was.  I used MIN() to get the text value for the quartile.

Regards

Phil

[Anonymous]

Thanks