- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The conditional formatting is for numerics only, not text
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Subject | Author | Posted | |
---|---|---|---|
07-03-2024 04:55 AM | |||
06-13-2024 01:13 AM | |||
04-08-2024 04:14 AM | |||
10-07-2024 11:33 AM | |||
01-29-2024 09:33 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |