How to show null values when filtered?

[Femke_DPG]

Hi all 

I want to see the null values, when filtering on week. For example: if I filter on week 2, I want to see the whole line, also the null values:

Now I see this, so only where it is filled in: 

Can anyone help me on this please? 

Appreciate! 

Thanks

Femke

[Or]

If these values are actually null in your data (that is, there is a data row with the combination of dimensions that is showing null) this should happen automatically. If these are missing intersections (that is, there is no data associated with this combination of dimensions), I can't think of a way to do this that doesn't involve filling in the missing combinations in the script or inserting dummy data.