Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Gamze
Regular Visitor

Issue with Clustered Column Chart in Power BI: Missing Months on X-Axis

I'm using a Clustered Column Chart in Power BI where the X-axis represents the first 11 months of the year. While the data for all 11 months exists, the labels for months 1, 3, 5, and 7, 9 and 11are not visible on the X-axis.

 

Gamze_0-1733576769105.png

 

1 ACCEPTED SOLUTION
qqqqqwwwweeerrr
Super User
Super User

Hi @Gamze 

 

Looking at you image appears to me that the axis is on continuos format check the x-axis format and try changing it to categorical instead of continuous.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

View solution in original post

2 REPLIES 2
qqqqqwwwweeerrr
Super User
Super User

Hi @Gamze 

 

Looking at you image appears to me that the axis is on continuos format check the x-axis format and try changing it to categorical instead of continuous.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

Expiscornovus
Super User
Super User

Hi @Gamze,

 

Can you share what you are using in your x-axis? Is the field you are using of type Date and are you using a Date Hierarchy?

 

datehierarchy.png

 

 



Happy to help out 🙂

I share #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.