Keep conditional formatting on filtered results - but STILL using minimum and maximum values

[vanlyplh]

Hi Everyone:

I have a report that has a column/data field that contains web links that take you to a single customer filtered version of the 'main' report.  In the 'main' report I have a table visual that uses conditional formatting for a metric that uses Minimum, Center and Maximum values to code a KPI.  When I click on the web link, the filtered results lose the 'proper' conditional formatting.(They all become green, suggesting good.  They aren't all good).

For scalability reasons, I can't use hard coded numbers, since the distribution centers are likley to change. (I did already see the post on using hard coded numbers. That solution won't work).

Is there a way to keep the color for each customer in the single customer, filtered page?  More simply put, I need green to stay green, red to stay red, etc.  (again, I can't use hard coded numbers)

[v-ljerr-msft]

Hi @vanlyplh,

Based on my experience, there is currently no any alternative ways, but use hard code values for conditional formatting in your scenario.

However, if we could set conditional formatting based on a different measure(we cannot now), then we will be able to keep condition formatting in a specific context we need. So I would suggest you vote this similar idea up and add your comments there to improve Power BI on this feature. 

Regards