Date formatting on x axis

[aguerrero]

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.

[WillT]

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]

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

[melissa_dor]

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

[ElliotP]

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