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! 

v-tejrama's avatar
v-tejrama
Community Support
1 year ago

Hi mdm2025,

Has your issue been resolved?If the response provided by speedramps  addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!