@svela, please refer this similar post Would it be possible to show a month in a chart even if it has no data? to show missing months data in a chart visual. In case you are not able to add dummy rows of the data to your dataset, you can create a dummy table that will have 1 row of data for each month (Jan to Dec) for each year and join this dummy table to your data table as outer-join such that dummy month rows will be included in resulting dataset if your dataset did not include a specific month data.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Missing and Extra Months on X-Axis in Line Chart Visualization | 2 | 80 | October 15, 2025 | |
| How to show all the date in x-axis instead of week wise gap? | 8 | 2137 | January 21, 2025 | |
| Would it be possible to show a month in a chart even if it has no data? | 6 | 1743 | May 8, 2025 | |
| How to correct date label in X-axis? | 2 | 369 | September 24, 2023 | |
| Not able to show all data points for X axis in line chart | 10 | 815 | April 30, 2024 |