@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.
1 Like