Forum Discussion

AhmadImbaidin's avatar
AhmadImbaidin
Frequent Visitor
2 years ago
Solved

calculation groups and conditional formatting issue

Hello everone,   am facing an issue with conditional formatting when am using the matrix visual with calculation groups.   As you will see in the picture below, the conditional formatting for the...
  • ValtteriN's avatar
    ValtteriN
    2 years ago

    Hi,

    I recommend using SWITCH to achieve this. In practice this would be something like this:

    P&L measure = var _line = MAX('Table'[Account]) return
    SWITCH(TRUE(),
    _line = "Total Other Exp.", -1*[P&L SUM],
    _line = "Revenue" , [P&L SUM])


    Here you should include logic for all the different cases. The two above are just examples. [P&L SUM] should contain sum of relevant accounts. Additionally I do hope your data is mock data. It is not a good idea to post accounting data to any forum.


    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

ValtteriN's avatar
ValtteriN
Community Champion
2 years ago

Hi,

I recommend using SWITCH to achieve this. In practice this would be something like this:

P&L measure = var _line = MAX('Table'[Account]) return
SWITCH(TRUE(),
_line = "Total Other Exp.", -1*[P&L SUM],
_line = "Revenue" , [P&L SUM])


Here you should include logic for all the different cases. The two above are just examples. [P&L SUM] should contain sum of relevant accounts. Additionally I do hope your data is mock data. It is not a good idea to post accounting data to any forum.


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/