cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wcurtis Frequent Visitor
Frequent Visitor

Column chart skips every other month on x-axis

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.

1 year chart.JPG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Column chart skips every other month on x-axis

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

 

Thanks

Raj

4 REPLIES 4
Super User
Super User

Re: Column chart skips every other month on x-axis

Hi @wcurtis,

 

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

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




wcurtis Frequent Visitor
Frequent Visitor

Re: Column chart skips every other month on x-axis

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.

1 year chart 2.JPG

Highlighted
Super User
Super User

Re: Column chart skips every other month on x-axis

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

 

Thanks

Raj

wcurtis Frequent Visitor
Frequent Visitor

Re: Column chart skips every other month on x-axis

Raj,

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