Conditional formatting not working when column value in data source is spread to columns in Matrix

[Anonymous]

Hi

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 .

	metricA	metricB	metricC
Country	7	5	3
State	6	8	2
City	8	7	1

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.

Any help appreciated

[Vvelarde · Accepted solution]

@Anonymous 

Hi, you can obtain this, using a Conditional Formatting - Format by Field Value (Use the measure)

and to assign the colors a measure like this:

Colors =
VAR _MAX =
    MAXX ( ALLSELECTED ( TableA[Category] ), [SumLikes] )
VAR _MIN =
    MINX ( ALLSELECTED ( TableA[Category] ), [SumLikes] )
RETURN
    SWITCH ( TRUE (); [SumLikes] = _MAX, "Green", [SumLikes] = _MIN, "Red" )

Regards

Victor

Lima - Peru

[Anonymous]

Thanks @Vvelarde I was able to implement change using your suggestion. 

Regards,

Rakesh.