Forum Discussion
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 ...
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.
Also when i arrange the column by descending, the dates are arranged correctly. the top is the latest appended values from feb 2021, and everything seems ordered properly all the way down