March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 this possible?
Solved! Go to Solution.
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.
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?
Well, 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.
The conditional formatting is for numerics only, not text
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
167 | |
117 | |
63 | |
57 | |
50 |