I am facing issue with conditional formating in Matrix visual. I have create hierarachy to enable drill functionality in Power BI.
Currently, I receive data in the following format and the amount of data that i receive is huge.
Columns name: country, state, city, score, metrics. number of response
My output visual that I have created looks like below .
The value that is visible above is calculated measure (weighted average of response and score). To create this visual i added hierarchy in Rows, in columns i added metric and in values i added calcuated measure (weighted average).
Now the issue I am facing is while doing conditional formatting. I am not able to do conditional formatting at metric level (metricA, B, C). If I do conditional formatting by measure that I created, it is taking all values in the measure for calculating minimum and maximum value. However, I want the series for conditional formatting should be different for metrics A, metric B and metric C.