Forum Discussion
Helper IIHide matrix row with value 0
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.
Helper IIHi 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 ;-(
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.