Conditional formatting in unpivoted columns

[AishwariyaV]

Hi

I have three columns

1. Variance (Budget vs actual),
2. Budget
3. 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.

[v-cherch-msft · Accepted solution]

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]

hi @v-cherch-msft ,

Thank you so much. It worked well.

Is it possible to do this in Data Bars instead of Background color ??