Forum Discussion
Power Bi Matrix - hide rows if total is zero
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.
2 Replies
- lbendlinSuper User
Create a measure that calculates to BLANK() for all cells in that row of the visual.
- AnonymousNot applicable
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