Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |