Empty Months in X axis

[mad104]

This graph has items sold per month and the quantities. I would like to show the months even if a product has not been sold then. I am having trouble showing those months with no values in them.

The first graph has all the months from 8/21-9/22

The second graph is after I selected a couple filters like salesperson or item number. I would still like to see those empty months where nothing sold.

Is it possible to show the months (with no values / bars) after a filter selection? If so, can anyone help me?

[rbartley · Accepted solution]

Hi @mad104 ,

Have you tried altering the definition of your measure to ignore all selections, e.g.

Sum({1} Value)?

If you need to include some selections but not others, then just exclude those selections, e.g.

Sum({<[Fieldname]=>}Value) 

[mad104]

Hello @rbartley, 

Thank you for this solution I am just unsure how I need to apply this now.

I will try to make it work, thanks again