Forum Discussion
Solved
Conditional Formatting Based on Measure using Slicer Selection Without Visual Interaction
Hello everyone, I'm facing a challenge with setting up conditional formatting in a Power BI visual using a calculated measure. I’ve created a measure and applied it in the Field value section of ...
Click here to download a solution from Onedrive
How it works ...
Create a detached picklist table
Create a measure
RAG = var mypicks = VALUES(picklist[Customers]) var mygraph = SELECTEDVALUE(yourdata[Customers]) RETURN IF(mygraph in mypicks, "Red")Add conditional formating to the column
Please click the thunbs up and the [accept solution button].
Many thanks!
Hi again MDM
Glad that the problem has been solved.
Hope you learned something new about detached picklist and Dax.
Thanks, speedramps