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!
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!