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

    Thank again for your feedback. The only reason I'm trying to do this is to have a vertical table instead of an horizontal one 🙂

     

    Talk to you soon and have a nice day!

  • 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!

     

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.