Custom Conditional Formatting with Calculation Groups

[Archer]

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 ?
Note: It works for positive & negative values however I want to control every cell background color
Matrix.JPG
Many thanks
Archer

[BrianJ]

@Archer,

I’d be happy to be proven wrong, but based on the research I’ve done on this question I don’t think it’s currently possible using calculation groups:

Conditional format negative percentages

@suzanne, This is a cool concept, and I would love to be proven wrong here but I don’t think it’s possible to fully automate this in the way you are requesting. I think to implement this type of logic based on measure name, you would need to use calculation groups. While you can dynamically format strings using this technique https://www.sqlbi.com/articles/dynamic-format-strings-with-calculation-groups/ at this point you can’t apply font or background colors in the same way via tabular models…

• Brian

[Archer]

@BrianJ
Yes you are right ! there seems to be no work around or hack as of now to achieve this
thanks for your response & assurance. Moving on

[BrianJ]

@Archer,

I haven’t seen the Power BI roadmap for this year, but it wouldn’t surprise me at all within the next few months if this becomes a feature added within one of the monthly updates. Seems they are always adding new conditional formatting options into the mix. Will keep my eyes out for this…

– Brian