Hi
I am starting to play with Power BI and am trying to do some conditional formatting on a matrix.
The measure that I have written works but has hard-coded values. The conditional formatting itself is being done on the measure using the rules of if value is 0 then colour white, if 1 then colour red.
<tbody>
</tbody>
I have tried using,
However, I get an error saying Utilisation is not a single value.
Any guidance will be gratefully received.
I am starting to play with Power BI and am trying to do some conditional formatting on a matrix.
The measure that I have written works but has hard-coded values. The conditional formatting itself is being done on the measure using the rules of if value is 0 then colour white, if 1 then colour red.
Is it possible to have a lookup against the Resource table rather than hard-coded values?Conditional Formatting = MAXX(Resource, IF(Resource[Grade]="Consultant"&& [Efficiency Measure] <=.95, 1, IF(Resource[Grade]="Managing Consultant"&& [Efficiency Measure] <=.75,1, IF(Resource[Grade]="Senior Consultant"&& [Efficiency Measure] <=.85, 1, IF(Resource[Grade]="Principal Consultant"&& [Efficiency Measure] <=.75, 1, IF(Resource[Grade]="Director"&& [Efficiency Measure] <=.60, 1 ))))))
Resource Code | Resource Name | Department | Grade | Utilisation |
Consultant | 0.95 | |||
Managing Consultant | 0.75 | |||
Senior Consultant | 0.85 | |||
Principal Consultant | 0.75 | |||
Director | 0.60 |
<tbody>
</tbody>
I have tried using,
IF ([Efficiency Measure] < Resource[Utilisation], 1, 0)
However, I get an error saying Utilisation is not a single value.
Any guidance will be gratefully received.