Forum Discussion

archerjayden's avatar
archerjayden
Helper I
5 years ago

Custom Conditional Formatting with Calculation Groups

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

DAX Calculation

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    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's avatar
      archerjayden
      Helper I
      5 years ago

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

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

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