Conditional Formatting - Excel

[Tevon713]

Hi all.

I tried to replicate conditional format in excel to power bi.  Look to be okay, the issue is when someone select single value in the data column it turn green which is not correct. Is there way for the value to remain static not change by the filter?

[edhans]

If you don't want a particular value to be affected by a slicer, you need to select the slicer, go to Format options, Edit Interactions, and disable the filter interaction on the destination visual.

In the below image, the country slicer will have no impact on the table visual shown because I've turned off the interactions for it.

[Tevon713]

Thanks but what I'm looking for is as follow. 

For example, Site 6 is red as when conditional formatting for overall... but when let say user want to see just single site should remain red but it green. Granted the formatting is correct when looking at the list. In excel when you filter for a single site, it will display correctly doesn't change. Hope I'm making sense.

PBI

EXCEL

[edhans]

You need to change the conditional formatting rules to use absolute values. when in a range of 500 to negative 200, negative 200 is red, but when it is the only thing, then it is the highest value, so it turns green because you are using the range settings, which change with each filter.

Excel isn't changing the filter context, it is just hiding rows.

[Tevon713]

Understood about conditional format in range. Sound like I have to write custom dax expression to achieve hide and unhide similar to Excel. Actual data is couple hundred thousands rows. I thought be easier method.