Forum Discussion
Hide matrix row with value 0
Hi guys,
I have an issue using matrix in PBI.
I'd like to remove my row when it has value 0 becaume my report becomes too long with many rows without values as you can see from the sreenshot.
Do you know how to do it please?
I had to put measures in rows instead of in columns but now I'm sutck here.
Thank you very much!!
Hi pasno ,
I looked at the structure in detail and realized that Trasporti and Magazzino are one and the same in matrix, and even with filters they can not change.
So I think it is more difficult to try to implement it in matrix, but it would be easier to choose table visual.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
10 Replies
pasno Can you use the Filters pane?
Hi Greg_Deckler
thank you for your answer.
I did it but removing blank rows it remover also customers that has a value on "Trasporti" (first row) and not in "Magazzino" (second row).
So I lose some sustomers from the list and I get only the ones that have some values in "Magazzino"...
Hi pasno ,
To remove rows with a value of 0 in Power BI without affecting other data, you can use a filter on your matrix visual.
Firstly you can create a new measure that will check for non-zero values in the columns.
NonZeroCheck = IF ( [Passivo Trasporti] > 0 || [Passivo Magazzino] > 0, TRUE, FALSE )This measure returns TRUE if there’s a non-zero value in either “Passivo Trasporti” or “Passivo Magazzino”. Add this measure to the filters pane in your matrix visual. Set the filter to show items when NonZeroCheck is TRUE.
This way, you will keep rows where either “Passivo Trasporti” or “Passivo Magazzino” has a non-zero value, ensuring that customers with values in “Trasporti” are not removed when “Magazzino” is zero.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
