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

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

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
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors