Custom Conditional Formatting with Calculation Groups

[archerjayden]

Hi,
I have 12 measures with 17 variations so I have implemented Calculation Groups and built matrix full of them in Power BI. Now I want to apply custom conditional formatting based on these calculation items and it doesnt work.
My Calc groups are Current Period and Calc Items are Actual, Fcst, BDGT etc.,
When I try to reference from my calc group the current period column and write an if condition nothing displays just blank. Is this possible at all ?

Matrix.JPG
Note: It works for positive & negative values however I want to control every cell background color

Thanks

Archer

[lbendlin]

interesting. I'll have to try that, I thought that they behave like regular measures.

[lbendlin]

Create a second set of calculation groups that computes the desired color value (instead of the measure value). Then set your conditional formatting to be based on field value.

[archerjayden]

Hi @lbendlin  thanks for your response ! conditional formatting is not recognizing calc group fields .. it is greyed out for selection unfortunately