Forum Discussion
Accounting balance remove zero rows
Hi,
Thanks for the solution Joe_Barry offered and i want to offer some more information for user to refer to.
hello Bokazoit , if you want to hide the value that returns 0, it is better that you use the table visual instead of matrix, because in matrix visual, the values of 2021 and 2022 are mutually influential, as long as one of them is 0, the entire data will be hidden. you can refer to the following similar thread.
Solved: Hide matrix row with value 0 - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think You need to read my post again. I am aware of the functionality of using the measures and I know that it should not remove those with data previous years. That is not what I am aksing about. I seek a solution were the rows with zeros in the above picture account 5030 is removed as an example but not 5028 or 5029