Forum Discussion
ahuhn
Advocate I
Advocate Imake slicer selections different font colour
I have a slicer with 3 options: US, EU, ASIA. I would like to be able to change the font colour for each of these options. I would like US to appear Blue, EU appear red, and ASIA appear green. Is thi...
You create a numeric measure for it like:
Measure = VAR __value = MAX('Table'[Column]) RETURN SWITCH(TRUE(),"USA",1,"EU",2,"ASIA",3)Or, create a column that assigns a number based on the text value. Base your conditional formatting on this measure or column.
ahuhnAdvocate I
Advocate IThe conditional formatting is for numerics only, not text
Greg_Deckler
Community Champion
Community ChampionYou create a numeric measure for it like:
Measure =
VAR __value = MAX('Table'[Column])
RETURN
SWITCH(TRUE(),"USA",1,"EU",2,"ASIA",3)
Or, create a column that assigns a number based on the text value. Base your conditional formatting on this measure or column.