Forum Discussion

pasno's avatar
pasno
Helper II
2 years ago
Solved

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. D...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

pasno Can you use the Filters pane?

  • pasno's avatar
    pasno
    Helper II
    2 years ago

    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"...

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.

      • pasno's avatar
        pasno
        Helper II
        2 years ago

        Hi Anonymous ,

        thank you for your feedback.

         

        I understand your answer but I need to remove the row "Passivo Magazzino" every time it is 0.

        For one customer that has a value in "Trasporti" but 0 in "Magazzino" I need to see just one line with the value but not the "Magazzino" line if it's 0.. This idea is not working ;-(