Hi,
I’m working on this line chart where I want to show a 0 for any nulls. I need to use full nulls because source nulls doesn’t give a 0 when there’s on data to begin with. The issue is with full nulls is as follows, if I have a chart with the following data:
a. 30
b. 45
c.
d. 10
e. 20
Now the full nulls ensure that c show a 0 rather than nothing which is what I want. The problem occurs when I have a filter that says, for example) only a to c. What will happen is this:
a. 30
b. 45
c. 0
d. 0
e. 0
It will show 0s for d and e which I want filtered out. Is there a way to keep that 0 on c but for it to recognise that d and e are supposed to be filtered, therefore showing nothing on d and e?