Forum Discussion

mdm2025's avatar
mdm2025
Helper I
1 year ago
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 ...
Need Help
Tips and Tricks
  • speedramps's avatar
    speedramps
    1 year ago

    Click here to download a solution from Onedrive

    Click here 

     

    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! 

speedramps's avatar
speedramps
Super User
1 year ago

Hi again MDM

 

Sorry you are still having problems

 

Please click on the Onedrive link in my original answer. Check it works ok. 

 

Once you proved to yourself that the solution works, then repeat my instructions more carefully.

 

Don't make changes (eg uses relationships).

 

Focus yourself on copying the instructions exactly. It will work.

mdm2025's avatar
mdm2025
Helper I
1 year ago

Hi speedramps ,

 

You are correct. Thank you againg for following up.

Not sure what I have changed but it works now 😄.

I have also update the DAX formula with additional conditions among which is having the blue default if no values from the slicer is selected( in case heplful for other community members in the future). 


All the best!