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.

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 ;-(

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi pasno ,

To remove rows with a value of 0 in Power BI, I think you can click on the matrix visual where you want to apply the filter. Go to the Filters pane on the right side of the report canvas. Under the Visual level filters, find the “Passivo Magazzino” field. Set the filter to show items when the value is not equal to 0.

For the scenario where you have a customer with a value in “Trasporti” but 0 in “Magazzino”, and you want to display only the “Trasporti” line, you would need to apply a similar filter to the “Passivo Magazzino” field. However, if these are two separate fields and you want to maintain the visibility of “Trasporti” values, you might need to consider creating a measure that checks the value of “Magazzino” and only returns the “Trasporti” value if “Magazzino” is 0.

Here is a change about the DAX code.

Trasporti Value = 
IF(
    SUM('Table'[Passivo Magazzino]) = 0,
    SUM('Table'[Passivo Trasporti]),
    BLANK()
)

If you can provide me about your .pbix file, I will have a further study.

 

 

 

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 again for your support.

    I'm still stuck also with this solution. Please find below the pbix in which ou can find one customer that has this feature (so a value in "Trasporti" but not in "Magazzino").

    https://we.tl/t-4nE6QjJJlg

     

    I'd like to see only the row with the value and not the one with 0.

     

    Thank you very very much again,

    Daniele

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi pasno ,

      I opened your .pbix file but I do not know which Measure should I select. When I select all of the Trasporti and Magazzino, it gives me blank on Magazzino,with no zero on Magazzino but has number on Trasporti . Colud you tell me more about this?

       

       

       

      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 

        in the pbix you can fine one customer "Acqua" with the two metrics that shows the costs (Passivo trasporti and Passivo Magazzino).

         

        This is the case in which I have a value only in the "Trasporti" area but not in the "Magazzino" one, so I expect to see just one row, the one with values.

        But if I add a filter to remove "Passivo Magazzino" when it's 0 or null it doesn't work!