Conditional formatting incorrect with hierarchy slicer

[PhilipE]

Hello,

Did anyone experience a similar issue with conditionnal formatting before? 

The rule is set on a % measure:

0% <= red < 60%

60% <= orange < 70%

70% <= green <= 100%

The formatting works fine except when I slice the data with a hierarchy slicer.. in some cases.

Below result should be formatted in green. 

Any ideas?

Tks !!

[Mariusz · Accepted solution]

Hi @PhilipE 

Try to set your conditional formatting like this.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.