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

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

Anonymous's avatar
Anonymous
Not applicable
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