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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
FM-Rad10
Frequent Visitor

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")

 

 

FMRad10_0-1711624985141.png

 

image.png

 

 

 


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? 

1 REPLY 1
lbendlin
Super User
Super User

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

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.