Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

dynamic conditinal formatting based on mtrix condition

Hi there, When you have a martix with Actuals and Budget columns the precentages and color coding make sense when the matrix colapsed but when you expand the matrix it dosen't make sense to have col...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi there,

     

    This one works and I did conditional formatting based on that

     

    Formatting =
    VAR Percentage = [Actual Vs Budget]
    VAR CheckExpand =  Not(HASONEVALUE(GLedger[Month Name])) ||
        Not(HASONEVALUE(GLedger[GL_ACCT_TYPE])) || NOT(HASONEVALUE(GLedger[DD]))
    RETURN
    If(CheckExpand = TRUE(),
       Percentage,0)
    Thanks
    Oded Dror
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Anonymous ,

     

    Glad I could give some pointers to get the solution don't forget to mark your result as the answer for this post to help others.

     

    Regards,

    MFelix

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi there,

 

This one works and I did conditional formatting based on that

 

Formatting =
VAR Percentage = [Actual Vs Budget]
VAR CheckExpand =  Not(HASONEVALUE(GLedger[Month Name])) ||
    Not(HASONEVALUE(GLedger[GL_ACCT_TYPE])) || NOT(HASONEVALUE(GLedger[DD]))
RETURN
If(CheckExpand = TRUE(),
   Percentage,0)
Thanks
Oded Dror
MFelix's avatar
MFelix
Super User
7 years ago

Hi Anonymous ,

 

Glad I could give some pointers to get the solution don't forget to mark your result as the answer for this post to help others.

 

Regards,

MFelix