4 Replies Latest reply: Oct 13, 2016 6:14 AM by Amien Amien RSS

    show all dimensions in bart chart, even when value = 0 or Null

    Amien Amien

      I have a bar chart in sense. When i select a specific client, i want to see all months in my bar chart, not only the months where the client bought something. So i should see this

       

      jan : 50

      feb : 60

      mrt : 0

      Apr : 0

      May : 10

      etc

       

      How can i do this? I have linked a full master Calendar.

      I dont want to add 0 values to the fact table, because i have to do this for every possible dimension

       

      any ideas? i tried all check boxes available

      Thanks in advanced