Conditional Cell Formatting - two different values on same dimension & Dates

Questions & Answers
1

Hello, I have a calculated measure that calculates the days between two dates. Let’s call this column Business Days . And for this , I used the formula,

(
DateDiffWorkdays([Measures].[start date],‘today’)
)

I can use conditional cell formatting to color between range of days, example if business days are 0-10 green and >10 red.

But I’m looking to have colors based on another field, which is “labels”.
If the issue has “label A” then color ranges are <10 green & >10 red.
If the issue has “label B” then color ranges are <20 green & >20 red.

Any help appreciated. Thank you.

1 Like
2

I was able to solve this by risk chart mentioned in the below post. Thanks @daina.tupule

1 Like