I'm not sure if your zero's are row level (i.e. the base data) or are after you've performed an aggregation eg. SUM([Sales])...I'm assuming the former (let me know if it's the latter!)
Add a calculated field
[Remove Zero Rows Filter]
[MyValue] <> 0
Add this to the filter shelf, and select 'True'
Hope that helps.
You can try to create a filter based on a calculated field:
SUM([Sales])>0 OR SUM([Sales])<0
Place the calculated field into the mark card and set that on true and it should work.
Hope this helps,
Thank you so much, this has worked perfectly
Thank you so much, this answer also works perfectly