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.
Greg_Deckler
Community Champion
Community ChampionWell, not in a slicer. You could put the three in a table and use Conditional Formatting. Depending on what you are doing, selecting a row in a table is pretty much a slicer.
ahuhnThe conditional formatting is for numerics only, not text
- Greg_Deckler
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.