Line Chart X-Axis

[Polygon]

I have a line chart that when filters the X-Axis (Which are month-YR) omits some of the labels, I assume because of space.

I tried to increase the size of the Line Chart; it helped a little; some of the labels showed; but some were still missing

So for example, Looking at 2020 line chart; Feb 2020, Mar 2020, Apr 2020, May 2020 etc. show but Jan 2020 doesn't?

2019 shows Jan 2020 Apr 2020 Jul 2020 Oct 2020 etc

How do you force to show all months?

Consumer wants to show all months.  Validated that each month does have data associated with it, it shows in the cart; just the label isn't there.

Has anyone run into this before?

Pictures attached

Thank you for your assistance in advance

[Pragati11]

Hi @Polygon ,

Click on your chart, go to format options, under x-axis, make your axis CATEGORICAL.

This should resolve your issue.

Thanks,

Pragati

[amitchandak]

@Polygon , In Visual format properties. You have an option in X-axis , Type. Make it categorical

[Polygon]

It is Categorical.

I even tried switching to Summary and then back; same result...  

[Pragati11]

Hi @Polygon ,

Categorical should have solved your issue. Because I see that working at my end.

Can you share your pbix file removing any sensitive information?

Also is your x-axis a datetime value rather than just Date?

Thanks,

Pragati

[Polygon]

May I share with to you alone?  I would be happy to let you look at the PBIX; just don't want it on the internet wide open.

Thank you.

[Pragati11]

Hi @Polygon ,

Yes you can upload your pbix file in dropbox or use We Share and then share the link privately.

Thanks,

Pragati

[v-lili6-msft]

hi @Polygon 

Categorical should work well.

Not sure why it doesn't work in your side, could you please share your sample pbix file for us have a test, 

you could upload it to OneDrive for buiness and post the link by private message.

Regards,

Lin