Chart columns shown if value > 0

Hi all,

I have the below table which columns are automatically updated every month with new data.Table data.png

I created a chart in my App and set all columns as visible, then in the chart I have added those months columns in the "Chart columns" details - which columns to include.

I would like to show in the chart ONLY the months with data, which means data > 0. I tried to use the show_if option in the  columns "Data" menu but adding for instance this "[May 2022] > 0.00" but it does not work, it always shows "May 2022" even when value is 0.00

Show_if example.png

Any ideas?

Thanks in advance.

Solved Solved
0 10 3,733
  • UX
1 ACCEPTED SOLUTION

Create a slice on the table. Use the slice row filter condition to omit rows with zero values. Base your chart on the slice rather than the table.

Slices: The Essentials - AppSheet Help

View solution in original post

10 REPLIES 10
Top Labels in this Space