matrix visuals, don't show rows that sum to 0

[Anonymous]

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.

[Anonymous]

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

[daXtreme]

@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.

[Anonymous]

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.