Forum Discussion

pasno's avatar
pasno
Icon for Helper II rankHelper 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
Icon for Helper II rankHelper 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.