Forum Discussion

ahuhn's avatar
ahuhn
Icon for Advocate I rankAdvocate I
7 years ago
Solved

make 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...
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    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.

momo_07's avatar
momo_07
Regular Visitor
2 years ago

Hello Greg_Deckler I need some quick help from you. I'm essentially looking to have dynamic text heading in one text box with multiple slicer selections. Additionally, I'd like to assign different colors to each slicer. Is it possible to accomplish this in Power BI?