Adding years to Stacked Column Chart when there is no row for that year

[Anonymous]

I have a Stacked Column Chart where some years do not have a row of data. Is there a way to get the year to show up even though there isn't a row for that year in the table?

Thanks

[SamWiseOwl · Accepted solution]

Hi @Anonymous 

Create a table with all the items you need, join to the existing date, then use this years column in the visual.

Go to the Columns section,use the drop down and choose Show items with No Data.

Here is a blog on creating a calendar table: https://www.wiseowl.co.uk/blog/s2947/calendarauto-table.htm

If you have no date, copy the code and replace calendar auto with
Calendar("01 Jan 2023", "31 Dec 2024") or what ever start and end date you like 🙂