How to see non-existent weeks in the line chart?

[nenadvukovic]

Hi,

What I need to do to see all weeks on the x-axis, regardless if volume exists for a each week or not?

For example, if item A is selected, I would need to see in the line chart that there was nothing sold in weeks grayed out.

Thanks

[nenadvukovic · Accepted solution]

Disabling Suppress Zero-Values and enabling Show All Values and Suppress When Value Is Null makes it work. Correct?

[Peter_Cammaert]

Yes, it should. Did you try it? (Cannot open your document here, PE only)

[el_aprendiz111]

Hi,

1 option:

[nenadvukovic]

Peter, Yes, I've tried before replying myself. I only need to ensure that I join the calendar to have all weeks listed instead of using weeks from transaction dates. All good. Thanks for confirming