Forum Discussion

clteh9's avatar
clteh9
Helper I
2 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'

HarishKM's avatar
HarishKM
Super User
2 years ago

clteh9 Hello,
I will suggest  create a date table like.


Step 2: Select all column then unpivot it 
expected output will like this.


Step 3 : Close and apply your query then drag it to slicer and expect output like this.


Enjoy.

Thanks
Harish M
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!