Forum Discussion
I have problems with the dates in Pivot Table
syazaaoa95 Your 'dates' are in fact texts that look like dates and the pivot table merely sorts them in alphabetical order (0 - 9, a -z ). You need to transform them into real dates.
There are several way to fix that, depending on where the data comes from. If import from e.g. a CSV or TXT file, use Power Query the legacy import From Text to import the data and set the date format correct from the beginning. If the 'dates' are in an Excel sheet from the start use text-to-columns (on the Data ribbon) or the DATEVALUE function. The latter will transform the date text into a number which you can then format as a Date.
So, please tell a little bit more on the background of these 'dates' or experiment on your own with any of the above-mentioned options.
syazaaoa95 Your 'dates' are in fact texts that look like dates and the pivot table merely sorts them in alphabetical order (0 - 9, a -z ). You need to transform them into real dates.
There are several way to fix that, depending on where the data comes from. If import from e.g. a CSV or TXT file, use Power Query the legacy import From Text to import the data and set the date format correct from the beginning. If the 'dates' are in an Excel sheet from the start use text-to-columns (on the Data ribbon) or the DATEVALUE function. The latter will transform the date text into a number which you can then format as a Date.
So, please tell a little bit more on the background of these 'dates' or experiment on your own with any of the above-mentioned options.
I already got it. I changed the date format in excel before converting it into Pivot Table.
Thank you so Muchhhhh>