I am using a pivot table which show data, but i need to add background to cell where certain condition is true.
Condition - I am showing say(Actual Value and Thresold value) in two columns and i need when Actual Value is greater then Threshold value then particular cell background (Actual Value) appear to red.
Hello @mohitkaushik1
Although we do not have a direct method, but you can try this alternative:
You have two columns {Actual-value} and {threshold-value}
We can create a calculated field that will check the difference
Diff:
{actual-value}-{threshold-value}
Now, if diff value is greater than zero, then actual value is above the threshold value and we can use conditional formatting to mark it with your desired color.
-Add Conditional formatting on your pivot table visual
-Select actual-value column
-For “Format field based on” select your Diff calculated field column
-Set condition to be greater than zero and hit apply.
It will look like this:
Hope this helps.
1 Like
Thanks it work for me
1 Like