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.
I want to visualize in a matrix visual the sum of the balance of different accounts.
Rows = Accounts, column = Balance
But I only want to show the row of an account in the matrix visual if the sum of the balance of this account is NOT zero.
Does someone know how to solve this problem?
Thanks a lot in advance.
Hi @Anonymous,
Can you please share some dummy data to test? they will help us clarify your data structure and test the coding formula.
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Regards,
Moonlight
@Anonymous
You can for instance turn 0's into BLANKs in the measure. BLANKs do not show up in visuals. You can also put a filter on the matrix to filter out 0's.
Thanks for your answer.
The problem is the following:
There is an account "XY" with a sum of balance (150, 50, -200) = 0
-> no data record of balance is zero but the sum is.
So i don't want to show the rows in the matrix visual where the SUM of the balance of an account is zero.
I hope you understand what I'm struggling with.
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 |
---|---|
41 | |
19 | |
19 | |
15 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |