Notifications
Clear all
Topic starter
Hi Team,
When I tried to do Matrix in PowerBI, I have the attached data with '0' balances.
Can you please let me know how to hide those data with '0' balances, especially it could be an adjustment of the previous data and it shows '0' balance in total.
Please see attached for reference.
Thank you.
regards,
Aye
Posted : 21/06/2019 4:08 am
Hi Aye,
You could try applying a value filter to hide values < zero, but I'm not sure this will work where you have balances in the months leading to the grand total.
Mynda
Posted : 22/06/2019 5:40 pm
Topic starter
Thanks, Mynda,
That will do for the time being.
I will try to do Grand total in power query and filtered out 0 instead of turning on Grand total from Power BI.
Thank you.
Regards,
Aye
Posted : 25/06/2019 4:47 am
