Hello, I was making a line chart and then I figured out that I couldn't find an easy way of formating date in the x-axis for month/year instead of just year as is shown in the graph below. Does anyone know how i can change this?
Any help will be appreciated.
You need to use a date value on your x axis. You can create an EndOfMonth column in your Date table with EOMONTH('Date'[Date], 0) and use that on X. The visual with auto format the x values based on the scale shown. See below with zoom sliders in two positions.
Pat
You need to use a date value on your x axis. You can create an EndOfMonth column in your Date table with EOMONTH('Date'[Date], 0) and use that on X. The visual with auto format the x values based on the scale shown. See below with zoom sliders in two positions.
Pat
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
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.
