Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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?
Thanks for the help.
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:
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.
Pat
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.