Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
ahuhn
Advocate I
Advocate I

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 this possible?

1 ACCEPTED 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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
momo_07
Regular Visitor

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?

Greg_Deckler
Super User
Super User

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.