Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Visualización Financial Reporting Matrix

Good afternoon My query is about the financial reporting matrix. In the image above I show a part of my report but I have a problem since, in the areas that expand (for example implantation) t...
  • v-yingjl's avatar
    5 years ago

    Hi Syndicate_Admin ,

    To hide some specific values in matrix, you can try to write some if statements to filter it, like this:

    Measure = 
    IF ( SUM ( 'Table'[Sales] ) >= 25, SUM ( 'Table'[Sales] ), BLANK () )

    But you also have to consider that if the values you need to hide has multiple different conditions, the formula may become complicated.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.