Power Bi Matrix - hide rows if total is zero

[przwrz1]

Hi,

I've created simple aged receivables report following also this tutorial  https://www.sqlbi.com/articles/grouping-transactions-by-age-of-customers-in-dax/. But there are situations that the payment for the invoice is not yet reconcile with the amount due, so I have in one bucket invoice amount (e.g 60-90 days) and the payment in another one (eg. 0-30 days). In Totals is zero, which is correct value. How may I hide all rows where total is zero regardless data in the certain buckets?

P.

[Anonymous]

Hi @przwrz1 ,

Could you please share some sample data and the expected result to have a clear understanding of your question? I can do some tests for you.

You can save your files in some cloud sharing platforms and share the link here.

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Yuna

[lbendlin]

Create a measure that calculates to BLANK() for all cells in that row of the visual.