Forum Discussion

h4_dkj's avatar
h4_dkj
Icon for Helper I rankHelper I
5 years ago

Conditiional formatting on calculated columns

Hi   I have created two different meassuers #1 KPI_3_1_Budget = if('BUDGET_COMMITMENTS (2)'[ACCOUNT] >= 3000, f('BUDGET_COMMITMENTS (2)'[ACCOUNT] <= 7999, if('BUDGET_COMMITMENTS (2)'[CODE_B] =...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

h4_dkj , you can do rule base conditional formatting . Where you can use [real] <150000 red.

 

Of use color measure with filed value option

 

Switch( True(),

[Real] <150000, "red",

"green"

)

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

h4_dkj's avatar
h4_dkj
Icon for Helper I rankHelper I
5 years ago

But does that support varians of the target. My budget shows that for month 3 we have estaimated a higher amount then 150 000, so hard coding a number want help me.