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'

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

You should create a Calendar Table with a relationship (Many to One and Single) from the Exit Date to the Date column of the Calendar Table.  To your visual, drag Date from the Calendar Table.

clteh9's avatar
clteh9
Helper I
2 years ago

Actually i have 3 new columns created in order to toggle the x-axis display between DAY, MONTH and YEAR
DAY = format(table1(EXIT_DT],"dd/mm/yyyy")
MONTH = format(table1(EXIT_DT],"mm/yyyy")
YEAR = format(table1(EXIT_DT],"yyyy")

if DAY selected,expected display is 01/04/2023, 02/04/2023, 03/04/2023.......
if MONTH selected, expected display is 04/2023, 05/2023, 06/2023/.....
if YEAR selected, expected display is 2022, 2023

By creating calendar table with relationship, can the x-axis be sorted accordingly?
Possible to provide a simple pbix for reference? Thanks