- 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
Slicer border conditional formatting bug?
I've been trying to get a border on a slicer to be specific colours for each value and thought I was doing something wrong after building the measure and it always returned the colour as Dark Grey, so I went and followed this guide, just to be sure. https://radacad.com/set-power-bi-data-color-all-visuals-to-follow-same-color-for-the-same-data-point and it's still not working.
When I apply the measure below as conditional formatting I just end up with the Red colour instead of the ones specified by the hex in the colour table. It's almost like it can't find the values to match on.
lookupvalue(
'Colour'[Colour HEX],
'Colour'[Value],
SELECTEDVALUE('Data'[Closing]),
"Red")
I've checked the values to ensure they're matching between the parameter table and the data table and everything is correct. I can't for the life of me work out what the disconnect is here. I had thought there might have been a trailing space somewhere in the data but that's not the case.
If I apply the measure to a bar chart it works without issue so I know the logic/values etc are working as intended. Is this a bug?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just adding my +1 to this. I have a table of values to use in a slicer, a column for the color I want show the border of the slicer, and a measure in the table that is just a MIN() of the color. But it's just showing the MIN of all the colors (I also tried the lookup route and had the same result).
I wanted to use the slicer as a legend to a graph, but I guess I'll have to do a less attractive hack around it.
It seems weird that MS would add a conditional formatting on the border color, but not let it address each value in the slider? Or am I missing something?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
this matches my experience. it's like it just can't see anything other than the min value.
as conditional formatting goes it's not exactly a "feature" at this point.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-13-2024 12:02 PM | |||
10-23-2024 09:02 AM | |||
09-10-2024 05:36 PM | |||
12-22-2024 08:49 PM | |||
10-11-2024 05:25 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |