Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
Solved! Go to 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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |