Forum Discussion

sibincube89's avatar
sibincube89
Regular Visitor
3 years ago

Conditional Formatting Text color legend

What is the best way to have conditional formatting assigned to the text portion of a BI graph? Below is what is currently built to work as conditional color formatting for data cards (And it works ...
Need Help
Tips and Tricks
v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, sibincube89 

 

There is some conflict between the two formulas, do you see if this is the result you expect?

Color Measure = SWITCH(TRUE(),
[Adj FYDP UMD %]>-10    && [Adj FYDP UMD %]<=-0.005,"#F22916",
[Adj FYDP UMD %]>-0.005 && [Adj FYDP UMD %]<= 0.005,"#32A846",
[Adj FYDP UMD %]> 0.005 && [Adj FYDP UMD %]<= 10,"#F22917",
"#F7FA34")

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

sibincube89's avatar
sibincube89
Regular Visitor
3 years ago

Hello, v-zhangti The reason the two sets of DAX are different is due to the driving categories having different metrics.

CIV:

> -1.25% & <= 1.25% is considered "Green"

> 2.5% & <= 100% is considered "Red"

> -100% & <= -2.5% is considered "Red"

All others "Yellow"

 

OFF/ENL:

> -0.5% & <= 0.05% is considered "Green"

> 1.5% & <= 100% is considered "Red"

> -100% & <= -1.5% is considered "Red"

All others "Yellow"

 

I have these two conditional color formatting options working perfectly within data cards, but trying to combine the two into a single measure to work for text in a visual is not working. 

 

Any other ideas? 

 

Thanks!