Show all values in bar chart regardless of selection and nulls

[Anonymous]

Hi,

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)

My current measure is:

if(Count({1} [Department]) > 0,

Count({$<[VA.Month]={'$(=Max([VA.Month]))'}>}

     distinct ([%ItemID])),

    0)

Thanks!

Serena

[luismadriz]

Hi,

Do you want to fix that chart to always show 28 bars (7 departments in 4 groups) regardless of having nulls? and nulls showing as zeros, I suppose?

[Anonymous]

Hi Luis,

Yes, I want to show 35 bars (7 departments in 5 groups) regardless! Nulls should be shown as zeroes