Forum Discussion
Solved
Sorting chart by date
'DAY' will be displayed as X-axis in a chart but the 'DAY' is not sorted by date correctly. DAY = format(table1(EXIT_DT],"dd/mm/yyyy") Current display: 01/04/2023, 01/05/2023, 01/06/2023..... ...
Hi,
Refer to the attached PBI file.
To add on
- to sort 'Date name' by 'Date number' and sort 'Month name' by 'Month number'
It looks like it is an issue with the regional settings. In some countries the convention is that the day comes first, in other countries the month comes first. You've specified a format with the day first, but the regional settings are causing sorting assuming that the month is first. So changing the regional settings in PBI and/or on your computer might fix the issue.
If this has helped, please give it a thumbs up.