Forum Discussion

JD09's avatar
JD09
Advocate I
2 years ago

New Button Slicer (November 2023 Update)- Conditional Formatting

Hello, Can we achieve Conditional color formatting for the Button / Tile in the new button Slicer (November 2023 Update). I want to have Button / Tile with different backgroung color based on the c...
Need Help
JD09's avatar
JD09
Advocate I
2 years ago

Hi tcbassett ,
Thanks for the Revert!!
Have tried this approach, It Only return the HEX Code, but it does not fill the Button as required.

tcbassett's avatar
tcbassett
Frequent Visitor
2 years ago

Sorry JD09 wasn't posting as a fix.  I think this is a bug with the new slicer button.  Just showing what I tried and didn't work for me.  Same issue as when you tried the conditional formatting based on a column - always sets to the first value as nothing is selected on a button.  

 

My work around was to use an image.  I couldn't get a complete fill but I'm using the coloured dot in place of legend on the graph.  Good enough for me.

 

 

It's a similar measure to what I tried for the fill but it actually works to switch the image??

 

This video shows switching the images if it helps.  NEW Button Slicers in Power BI | 3 Examples You Don’t Want to Miss! - YouTube