Forum Discussion

Daretoexplore's avatar
Daretoexplore
Advocate I
2 years ago
Solved

Date axis

Hey   Hopefully very quick and easy question.   I'm setting some graphs over time up, however the date axis acting differently.   Ideally I need the date to go August 23 September 23 October...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    hi Daretoexplore 

     

    If you want that date format create a calc column, to have such a format. Make sure the date axis is set to categorical.

    Custom Date Format =
FORMAT ( 'table'[date column], "mmmm yy" )

    Custom Date Format sort =
FORMAT ( 'table'[date column], "yyyymm" )

    The first calc column will be sorted alphabetically so you'll need  another column to sort it by. 

     

danextian's avatar
danextian
Super User
2 years ago

hi Daretoexplore 

 

If you want that date format create a calc column, to have such a format. Make sure the date axis is set to categorical.

Custom Date Format =
FORMAT ( 'table'[date column], "mmmm yy" )

Custom Date Format sort =
FORMAT ( 'table'[date column], "yyyymm" )

The first calc column will be sorted alphabetically so you'll need  another column to sort it by.