Show all dimension values in chart

[Pedro_Rodriguez]

Hi all,

I'm facing an issue, I've simplified it in the attached file. There you can see 2 versions of the same line chart.

What I want to achieve is a mix of the two, meaning that I want all the months displayed in the chart dimension but its values interpolated in the  months where there are none. In short, I need the top chart axis, and the bottom chart display of values.

Thanks a lot in advance!

[Pedro_Rodriguez · Accepted solution]

Let me answer myself. I found a way by adding an additional field with a dummy value for each month and then making its expression invisible. Find attached.

In my real scenario I have additional fields populated in every record so I can use one of them and I don't need to create a new one.

Hopefully this helps someone in the future.