Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Afternoon, complete beginner to Power Bii and im having problems when collating data using dates and wanting them displayed in date order , the data is all mixed up on the graph . any assistance is greatly appreciated
Solved! Go to Solution.
Data Type: Ensure that the column containing dates in your dataset is formatted as a Date data type in Power BI. If it's not already, you can change the data type by selecting the column in the data model view and changing its data type to Date.
Sort By Column: In your visualizations (such as line charts or bar charts) that use dates on the axis, you can specify a sort order for the date column.
Sort By Date Hierarchy: If your date column includes a hierarchy (e.g., Year, Quarter, Month), you can also sort the visual by the date hierarchy to ensure proper ordering.
Data Type: Ensure that the column containing dates in your dataset is formatted as a Date data type in Power BI. If it's not already, you can change the data type by selecting the column in the data model view and changing its data type to Date.
Sort By Column: In your visualizations (such as line charts or bar charts) that use dates on the axis, you can specify a sort order for the date column.
Sort By Date Hierarchy: If your date column includes a hierarchy (e.g., Year, Quarter, Month), you can also sort the visual by the date hierarchy to ensure proper ordering.
Hi @MIshMash100
Please check if the date column is formattted as date. You can do this in Power Query. When this is done it will sort correctly
Joe
If you found my answer helpful and it solved your issue, please accept as solution
Proud to be a Super User! | |
Date tables help! Learn more
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
9 |