How to show zero values in the line chart for months where zero value in present
Hi,
I am trying to get zero value to be shown in the line chart. I have created a pivot table for the same data that I want to show in line chart. For the year 2024, 2023, 2022 i have created columns and the 2024 column contains zero value for the region for specific month. The same is done in line chart but the zero value for not shown in the line chart.
I have tried toggling all the options under missing data, but nothing worked.
Is the checkbox in Include 0 value Add-on is checked ?
In this case, b is Null(), and then you should replace it by 0 to display it, and for the d dimension, it's null and then displayed, with missing value show as 0
