bar chart with zero value

[koorosh]

Hi all,

How I can avoid bars with zero value in the following chart?

[AnalyticsWizard]

@koorosh 

1. Click on the bar chart to select it.
2. In the 'Visualizations' pane, find and click on the 'Filters' pane.
3. Drag the measure or column you're using for the bar values into the 'Filters on this visual' area.
4. Set the filter type to 'Basic filtering'.
5. Uncheck the box for '0' or move the slider to exclude '0' from the range.

This will ensure that the bar chart only displays bars for values greater than zero, effectively removing any bars that would represent a value of zero.

Remember, filtering out zero values can sometimes remove important information about the presence or absence of data, which might be relevant for understanding the dataset as a whole. 

[koorosh]

Hi, all months with zero values were removed from the chart.

https://docs.google.com/spreadsheets/d/11PGaDnfRb-AOylcnxkgI6kSZAATRdGAj/edit?usp=sharing&ouid=11435...

[MFelix]

Hi @koorosh,

How is you measure calculated? Do you have 0 in your dataset? So that the sum is 0?

Try to do a measure similar to:

Value = IF(sum(table[column]) <> 0, sum(table[column]))

This will return blank when the values are 0.

[koorosh]

check yourself, please.

https://docs.google.com/spreadsheets/d/11PGaDnfRb-AOylcnxkgI6kSZAATRdGAj/edit?usp=sharing&ouid=11435...