topic Custom Conditional Formatting with Calculation Groups in DAX Commands and Tips

Custom Conditional Formatting with Calculation Groups

archerjayden — Mon, 18 Jan 2021 19:58:23 GMT

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

Re: Custom Conditional Formatting with Calculation Groups

lbendlin — Mon, 18 Jan 2021 22:50:24 GMT

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.

Re: Custom Conditional Formatting with Calculation Groups

archerjayden — Mon, 18 Jan 2021 23:33:22 GMT

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

Re: Custom Conditional Formatting with Calculation Groups

lbendlin — Mon, 18 Jan 2021 23:55:24 GMT

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