Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |