Show all values in bar chart regardless of selection and nulls
I have the following bar chart and I currently am able to show all Overdue (Months) fields even if the selected month (Eg. Jan 2018) has nulls for that Overdue field (only < 3 Months values exist). I also want to show all 7 departments as seen in the '< 3 Months' section. There should be 7 zeroes for the other Overdue (Months) fields. How can I achieve this?
Dimensions: Overdue (Months; Total 5) and Department (Total 7)