Slicer Breaks Colour Formatting

[nickelcap]

Hello,

I created a chart that has some colour formatting set up with it. If a value exceeds 96, the bar is meant to turn red. This worked fine for me until I implemented a slicer that is meant to filter the report down to only values that are below this 96 threshold. When I do this, bars below a value of 96 are red.

The slicer is based off a column which is an if statement based off another column. It reads as: "IF(Appended[Hours Since Last Upload]>96, "Over Time Limit", "Within Normal Time Span")". The chart plots the max of 'Hours Since Last Upload', and colour saturation is set to be based off of 'Hours Since Last Upload'. The Axis is based on a hierarchy, with Customer above Asset, so that the user can drill down from one to the other.

I have Data colours set to Diverging Off, Minimum set to 95, Center is not set as anything, and Maximum set to 96. Minimum is green, center is white, and maximum is red. As I said, this works fine until I apply the 'Within Normal Time Span' side of my slicer. However, when I drill down to 'Asset' on the chart the problem goes away. See the images below:

No filterFilter CustomerFilter Asset

Is this a bug with Power BI, or have I done something incorrectly?

Thanks for any help you can provide.

Regards,

Dan

[Vicky_Song]

@nickelcap, could you please show me the data in the dataset you're using? You mentioned that "the Axis is based on a hierarchy, with Customer above Asset", however, there is no difference when drill into (except for the color for the 67.00 column), which is something different from my understanding about what the hierarchy means.

It will be better if you can provide me a screenshot shows how you design your report so I can better understand your scenario. 

---