Forum Discussion
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...
Hey, I was trying to get this to work too using measures.
My theory is nothing is selected in the button slicer so cannot set the value based on selection.
For example:
1. I use a simple measure to set the fill colour when selected. This works as not based on selecting an actual button value.
Simple Measure = "#0022BB"
2. Now try a measure based on selecting a value.
IF(SELECTEDVALUE(Slicer[Region]) = "Brisbane Region" , "#0022BB")
hmm, doesn't work. But if I filter the button slicer visual based on the region in the measure to "Brisbane Region"
It works!!!!
So I just have to filter the slicer to change the button colour to apply conditional formatting ;).
I have tried different options i.e. hasonevalue, but I guess the thing with that button is it isn't actually being filtered to one value to enable setting to a colour. Also tried switching based on values but just set to the last colour in the statement.
Missing something with the dax.