1 of 1 people found this helpful
You'd just use the filter, set it to not equal to 0.
You maybe able to do that on a single field, or you may have to do multiple, it depends on your data/ setup.
The other option is to create a calculated field
IF SUM([your field])=0 THEN 'hide' ELSE 'show' end
Set on the filter tab as Show.
Please post a sample workbook . it will be easy for looking at the issue.
If possible share your sample workbook or screen shots.
If you want to show values of 1 or greater, take the measure that contains the zero, drag it to the filters window. Set the filter to be 'At Least' with a value of 1.
If you want to show values of 0.0001 or even more decimals, just change this to whatever values you want to be displayed.
can u share the workbook . so that we can look at the issue.
Here I created a cal field (sum of 4 measures) and dragged it to filter and set the least value to 1.
If you need to add other measures add them to the cal
find the attached workbook, hope this helps
exclude zero line new.twbx 2.1 MB
Don't mean to be rude here, but given the Image above, I think the best solution would be Excel.....
There is possibly a way to get you to a solution, but it's not going to be pretty. Tableau just wasn't necessarily built to be used like Excel, so things like this have limitations.