Power Query-Date coming as mixed up in pivot table

[HdCpr]

Hello
I have a file where in my company , we keep record of sales
I want to use this file in power pivot table to see each day/month/quarterly to check and report what we sold,,,
but when i put on the pivot table dates are coming as not possible to group section or group field
i tried to use and power query to sort and move columns to rows ... but then dates coming up as mixed ....
is there any way to help to sort this out? as attached some screen shots

 

[Matt Allington]

You need to
1. Unpivot the date columns =>

2. Join the new date column to a calendar table => Create calendar Tables in Power BI

proceed from there.

 

[HdCpr]

You need to
1. Unpivot the date columns =>

2. Join the new date column to a calendar table => Create calendar Tables in Power BI

proceed from there.

Thanks for your time and help. Resolved ?