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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
wcassetty2
New Member

Line Chart x axis label

I am trying to show the months/years as the data labels in my line chart. The data is formatted as a date. I can use the date hiearchy to only show month and year, however, it reads year month (e.g. 2023 February). I would like for it to read Feb. 23. How do I get it to read like that?

wcassetty2_0-1676319992749.png

 

 

Thanks for the help.

2 REPLIES 2
wcassetty2
New Member

So I tried this solution, however, I am faced with an issue because I do not have the format type mmm yy in my format options. Shown below:

wcassetty2_0-1684174155539.png

 

 

ppm1
Solution Sage
Solution Sage

Here's one way to do it. Add a calculated column to get the end of month (EOM) from your Date column. Then set the format string for that column to    Mmm yy   

 

Create your line chart. If you leave the X axis as Continuous the labels will auto adjust, but if you want it to look like your picture then set it to Categorical and adjust the chart size until it looks like this.

ppm1_0-1676335217799.png

Pat

 

Microsoft Employee

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.