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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper III
Helper III

Bar Chart Missing X Axis Labels

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

Helper V
Helper V

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




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.



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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

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