Hi,
my x-axis of a line chart is the date of sales. Right now the x-axis only shows labels (e.g. June) for intervals I have data from. Is it possible to format the x-axis in a way that it shows labels for all intervals (January to December) even if there is no data for some of the months?
Thank you for your help in advance!
@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