Forum Discussion

aguerrero's avatar
aguerrero
New Member
10 years ago

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.

Need Help

4 Replies

    • melissa_dor's avatar
      melissa_dor
      New Member
      9 years ago

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

      • ElliotP's avatar
        ElliotP
        Post Prodigy
        9 years ago

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

  • WillT's avatar
    WillT
    Community Admin
    10 years ago

    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!