Forum Discussion

AishwariyaV's avatar
AishwariyaV
Icon for Helper IV rankHelper IV
7 years ago
Solved

Conditional formatting in unpivoted columns

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.