Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Post Patron
4 years ago
Solved

Conditional formatting

Dears,   i've the following column with some %, and i applied a conditional formating, but the colors are not as the ones i defined in the conditional formating below. can someone help me with this...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Zakaria_1980 ,

    Please create a measure as below and set the conditional formatting as below screenshot:

    Cond Formatting = 
SWITCH (
    TRUE (),
    [-Planning Accuracy_BVP (BP vs AC)] < 0.5, "Red",
    [-Planning Accuracy_BVP (BP vs AC)] < 0.9, "Orange",
    "Green"
)

    If the above one is not working for your scenario, please share some sample data or your simplified pbix file(exclude sensitive data) in order to provide you a suitable solution. Thank you.

    Best Regards

Zakaria_1980's avatar
Zakaria_1980
Post Patron
4 years ago

Thanks  alot, where shoud I put this measure please ?

 

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

In the conditional formatting interface, select Field and add the measure

  • Zakaria_1980's avatar
    Zakaria_1980
    Post Patron
    4 years ago

    it won't be selected see below snapshot

     

     

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      4 years ago

      Like this...

       

      • Zakaria_1980's avatar
        Zakaria_1980
        Post Patron
        4 years ago

        i don't know why it won't pick measures to click on OK.