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

See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap

Reply
karimk
Helper III
Helper III

Bar Chart Missing X Axis Labels

Hi,
I have a bar chart that shows the ammount of things I have to do per month, over the next 2 years.

My X axis is missing some labels, although I still get the bar.

 

If I change my X axis type to categorical, it will show the labels correctly, but not all months, even if I choose to show items with no values.

 

My excel database is as shown.
Any suggestions?


example 3.PNG

example 2.PNG

 

example 3.PNG

3 REPLIES 3
jdubs
Helper V
Helper V

Hi, just checking to see what the solution to this was. I have a similar problem. 

v-sihou-msft
Microsoft Employee
Microsoft Employee

@karimk

 

Can you try "show items with no data" when you select "Contiuous" on X-axis?

 

In chart visuals, when you select "Contiuous" and put a date field, it supposes to detect the date hierarchy and generate continuous dates on X-axis. 

 

If you select "Categorical", it will only show items which exists in your source table.

 

Regards,

Hi, thank you very much for the response. I actually didn´t upload a pic of the chart with bars showing, but no label.

Here it is. This is not date hierarchy, with a continuous x axis configuration and "show items with no data"

As you can see, the month of February 2018 has a bar with 1 item, but the label for "Feb 2018" is not showing

new example xaxis.PNG

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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