Forum Discussion
Conditional formatting in unpivoted columns
Hi
I have three columns
- Variance (Budget vs actual),
- Budget
- Actual.
I have unpivotted these columns using edit query. So these columns will be clubbed into a single column and will be named as "attribute" column and their corresponding values will be named as "value" column.
In matrix visual, i have added attribute column to Columns data field and value column to Value data field.
The problem is, i have to apply conditional formatting only for variance column and NOT FOR budget column and actual column.
Since these three columns are clubbed, conditional formatting is reflecting in all the three columns.
Hi AishwariyaV
You may create a measure like rule measure as below and use it in conditional formatting.
Rule = IF(MAX(Table2[Attribute])="Variance",1)
Regards,
2 Replies
- v-cherch-msft
Microsoft Employee
Hi AishwariyaV
You may create a measure like rule measure as below and use it in conditional formatting.
Rule = IF(MAX(Table2[Attribute])="Variance",1)
Regards,
- AishwariyaV
Helper IV
hi v-cherch-msft ,
Thank you so much. It worked well.
Is it possible to do this in Data Bars instead of Background color ??