Column chart skips every other month on x-axis

[wcurtis]

I have a chart with a slicer that skips every other month. I have selected less months and it still skips every other month. I have posted a snip of what this looks like. I have not found a solution to this issue. I use a slicer so the months will run correct from oldest to newest. If I do not have the slicer the months run alphabetically.

[MFelix]

Hi @wcurtis,

On the X-axis options change from continuous to categorical, should work.

Regards,

MFelix

[wcurtis]

That works but then I wind up with the chart looking like this. It has the day and date. I just need the month and year.

[Anonymous · Accepted solution]

Select your Date field in Fieds tab and set the format as Month, Year in Formatting options ( Modelling -> Formating).

Thanks

Raj

[wcurtis]

Raj,

Yes, that works perfectly, Thank you!!!!