Keep Line+Bar format even when Null or Zero

Sweep_The_Leg

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?

 

 

bar example.png

jaeW_at_Onyx

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.