How to relate date table with detail data table

[Anonymous]

Hi

I have a scenraio where i have created a date table from 2015 to 2020. I have detail data table where i have data just till 2018. Now I have a bar chart where i am showing data for every year where in i am taking year columnfrom date table.

Now the problem is that bar graph only shows data for years till 2018.

I want that those two years also come in the bargraph and replaced with 0 if theer is no data.

How can we achiee this.

Regards

Shilpi

[TomMartens · Accepted solution]

Hey,

from the context menu of the column used as x-axis, your year column from the date table, just select "Show items with no data":

Hopefully this alreay will provide what you are looking for.

Regards,

Tom