Keep Line+Bar format even when Null or Zero

I have a line+Bar chart, line is a target and the bars are each department (3 segments in each bar). problem occurs when I filter for any specific department, the bars collapse because there's no data for that specific department within that month. How do I keep the integrity of 6 segment and 2 bars even when there's no value?

 

 

Best Answer

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤
    Accepted Answer

    you would have to have a row for each department for each month.

    You can create a template dataset that has one row for each department with a fixed amount of 0, then UNION that to your actual dataset.

This discussion has been closed.