Forum Discussion
Pivot chart doesnt sort custom date correctly
Hi experts, I need the following format on my date "dd/mm/yyyy ddd" (31/12/2021 Sun) so I am using the format function on powerpivot to get the date in that format, however when I do that, my chart ...
Thanks Anonymous , I ended up solving the problem sorting out the column based on another col. which was date type
Hi Anonymous ,
The line chart can sort by the date field correctly even though set the format of the date field as "dd/mm/yyyy ddd" just as shown in below screenshot...
In addition, please review the content in the following links, hope they can help you resolve the problem.
Excel Won't Sort Dates Correctly - The Solution!
How to sort by date in Excel: in chronological order, by month, auto sort
Best Regards
Thanks Anonymous , I ended up solving the problem sorting out the column based on another col. which was date type