Static Dimension in Bar Chart

[CBRZ]

Hello,

Currently I have a bar chart showing monthly sales of different products.

When I filter on a certain product, the months then limit to only show the months where the sale was made.

Is there any way to keep the X-Axis static so even if I select a product that wasn't sold in all months, all months would still be represented on the x-axis but just no corresponding sales?

Thanks!

[sunny_talwar · Accepted solution]

May be try by adding this to your expression

+ Sum({1} 0)

[CBRZ]

Thank you!!