Issue with Monthly Labels in Power BI Bar Chart

[MollyChan]

Hey everyone,

I am a completely beignner with 2 days learning and I am really struggling with a question recently again.

I'm hitting a bit of a snag with a bar chart in Power BI. For some reason, it's only showing even months like February, April, June on the bottom labels, and it's skipping all the others.

I'm thinking it might have something to do with how I've set up the months in my raw data. cuz they're just numbers (1 for January, 2 for February, etc.), not text like 'Jan', 'Feb', and so on. I even tried changing the month column to a date type, but then they all turned into dates like 1990/1 rather than 2023/1

I've tried tweaking the size of the chart and messing around with the settin gs, but no luck so far. Has anyone else run into this or have any ideas on what might be causing it?

Many thanks!!!!

[amitchandak · Accepted solution]

@MollyChan , If you are using a date column on axis, it might be using a continuous axis.  Use Categorical Axis

refer if needed

Complete Power BI in one Video 11 hours: https://www.youtube.com/watch?v=cN8AO3_vmlY

Mastering Power BI 230+ videos: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=2

Power BI Concepts 160+ Videos: https://www.youtube.com/watch?v=59PUFuuCrbY&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L