Forum Discussion
Suppress blank/zero values in chart
Hello, super new to this.
Basically I have a simple bar chart with Date as dimension and a calculated measure "Lines OK" (nothing fancy, just count rows where a column has a specific value) as the value.
My problem is two example dates: 12th, 13th of september
With no filters, 12 sept has 0 as value and 13 sept is null/empty.
However my problem is that I put this into a chart, it shows 12th, 13th of september as giant empty spaces when I want them hidden, even though I have applied a filter "Show items when the value is greater than 0" in both table and chart. See below example, chart shows 12th and 13th as empty, while the table version correctly suppress them....
What have I missed? How do I achieve it so that 12, 13 september will not show in the bar chart?
Hi Anonymous
try to use a different x-axis format (see figure):
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
