Forum Discussion
Hot to apply Conditional Formatting to Calculation Groups and Calculation items
Hi somnath6309 ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra.
Hi Sam,
Many many thanks for your help. I have applied the rules as shown above and got the desired result.
However, I had created a measure named VALUE which equal to BLANK() and used the same in Matrix Value filed. When nothing is selected from the slicer Matric, it shows a blank table. Pls see below screen shot:
The Conditional formatting rules applied to the cell elements of the matrix, are actually getting applied to the measure VALUE and the formatting is getting applied to all the values. Pls vide the screen shot for reference:
However, this is to be mentioned that Sales Amount, Sales Qty, Total Cost cannot be negative for CY, PY as shown below. Mainly, YOY Pct and YOY can be both positive or negative.
Can you pls let me know whether there is any process / trick by which I can display amounts in CY and PY in Black ( regular color) and YOY Pct and YOY, both, in Red ( for negative value ) and Green ( for positive values) ?
Thanks.
Regards,
Somnath
Hi somnath6309
You need to create a measure that defines which to change colour:
Formatted font measure =IF(Not(SELECTEDVALUE('Calculation group'[Calculation group column])IN {"YTD", "Time Calculations"}) --Leave these two black,[Sum Qty],BLANK())Then use this as your conditional format field:
Enjoy!
