2 Replies Latest reply: Jan 10, 2018 4:52 AM by Mei Zheng Tay RSS

    Show all values in bar chart regardless of selection and nulls

    Mei Zheng Tay

      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)

      ageing-barchart.PNG

       

      Thanks!

      Serena