Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Line Chart unordered dates

I have created a power BI graph which includes a column for dates.    I've used this date column to create a Line Chart, with dates on the x axis. It has worked fine. [dates range from april 2020 ...
Need Help
Show and Tell
Tips and Tricks
  • Carmichael's avatar
    Carmichael
    5 years ago

    Just wondering if you are using the PBI Auto Time Date and if this is currently showing up as categorical data in the field well.  If so then the fix is to drill down using the Expand all rather than Drill to the next level in the hierarchy.

     

    Just in case my guess is right.

    - Drill back to top level (Year)

    - Ensure X is continuous

    - Use Expand all to drill down

     

    This is what I ended up with

    Please mark as the answer if this works or 'like' if it helped.  All kudos appreciated. 

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Anonymous 

Can you please share your PBIX?

Thanks

Phil

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Apologies I'm unable to do that. Is there anything I can on my end to help you understand the data?

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Anonymous 

    Providing the column of dates.  I can make up some data values.

    Regards

    Phil

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I have an excel spreadsheet with the dates