how to prevent zero values are displayed.

[vitexo87]

in the picture below I have a report that it have some measures and fields, as you can see has lines all values are zero, thus leaving the report with unnecessary size, how can I prevent these zero values are displayed?

[Sean]

@vitexo87 Use the Visual Level Filters => show when greater than 0

[vitexo87]

@Sean

when I do it even if it is just a measure of the other columns are zeroed only presenting the total, do not have a way to get it to display the values as I want without having to filter the report?

[Eric_Zhang]

@vitexo87

---

@vitexo87 wrote:

@Sean

when I do it even if it is just a measure of the other columns are zeroed only presenting the total, do not have a way to get it to display the values as I want without having to filter the report?

---

The visual level filter only affects that visualization and it won't filter the report. May I know why a filter is not preferred in a visual? Up to my knowledge, there's no other way than a filter. Or you may prefer a filtered calculated table or a filtered dataset when connecting the data source?