@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.
DeepakS
2
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Missing and Extra Months on X-Axis in Line Chart Visualization | 2 | 130 | October 15, 2025 | |
| How to show all the date in x-axis instead of week wise gap? | 8 | 2215 | January 21, 2025 | |
| Would it be possible to show a month in a chart even if it has no data? | 6 | 1776 | May 8, 2025 | |
| Line chart issue - data gaps | 11 | 531 | February 26, 2024 | |
| How to correct date label in X-axis? | 2 | 389 | September 24, 2023 |