Forum Discussion

clteh9's avatar
clteh9
Icon for Helper I rankHelper I
3 years ago
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..... ...
Need Help
  • clteh9's avatar
    clteh9
    2 years ago

    To add on

    - to sort 'Date name' by 'Date number' and sort 'Month name' by 'Month number'

KEAlexander's avatar
KEAlexander
Icon for Helper I rankHelper I
3 years ago

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.