Conditional Formatting based on a measure & dimension filter

[#1]

Hello All

I have a requirement where in a SAC Story table, have to highlight a story level measure value based on it value. And to add complexity, the threshold would change based on a country filter.

[PM8]

have you tried adding multiple threshold by adding country filter at each threshold ?

[Stephenkraj]

you can try with the basic conditional options

At the thereshold you can try these options

[N1kh1l]

stephen.kanakaraj

The range is different and not fixed and it will differ based on Country so a fixed setup based on threshold will not work.

godan, May be if you store ( table shown) those ranges in Measures in the model, You could use Compare to Measure option instead of Number ranges in Conditional Formatting.

Br.

Nikhil