Visualización Financial Reporting Matrix

[Syndicate_Admin]

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) the matrix performs a sum of the values that are within that item and those are the values that appear in those rows, but I do not expect to have a value per implantation but to see broken down what interferes there , so I'd like to hide those values from the deployment row. I tried to leave the values in white but in the same way the name of the concept remains and it is not what I am looking for, they could help me know how to hide those values without disappearing the rub.

Thank you!!

[annibape]

Financial reporting matrix has stopped working?
the report that I had made no longer loads this visual and it hangs, if I try to import it into a new report it also hangs.
What I can do?
best regards

[v-yingjl · Accepted solution]

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.