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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
aguerrero
New Member

Date formatting on x axis

I have Dates with values such as 2015-05-01, 2015-05-15 and 2015-05-29.  When I select that field for my X axis in a line chart it shows up as May 2015.  That's not what I need; I need the individual dates, not the dates aggregated into the month.  They are Payroll Dates and I need to show stats for the specific date.  Can you tell me how I can get it to display correctly? 

 

Thanks in advance.

4 REPLIES 4
WillT
Community Admin
Community Admin

Your data is still being plotted on the specific dates, Power BI is just labelling the axis at a month level. If you hover over the line you'll see a tooltip that gives you the specific date. Tishchenko's suggestion of changing the axis type is the right option if you do want to show each label, but it does mean that each point will be plotted with the same interval (so if your dates aren't evenly spaced it might be a bit misleading).

 

If this post helped (or Tishchenko's!) then please mark it as a solution so we know the thread's resolved! Thanks!

Tishchenko
Continued Contributor
Continued Contributor

Hi, try change X-Axis type to "Categorical".

2.png

When I try to format the X-Axis, the only Scale Type available in Linear 😞 How do I get "Categorical"?

The "date" column must be the Date or Date/Time format

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.