Conditional formatting On/Off switch

Hey lherbert501 ,

you can achieve what your are looking for.

Create a simple table with two values: On / Off. Use the column as a slicer, I recommend making the slicer a single select slicer.

Then create a measure that returns a hexcode like "#ffa500" for orange or what ever you need to create your conditional formatting. Wrapt this measure into a second measure like so:

apply conditional formatting =
var on_off = selectedvalue('<tablenameOnOff>{On/Off] , "Off" )
return
if(on_off = "Off" = "On" , [your measure that returns the hexcode] , blank())

Use this measure for the conditional formatting, make sure that you select the "Field value" option as the format style and then select the above measure [apply conditional formatting].

Hopefully, this provides what you are looking for, to tackle your challenge.

Regards,

Tom