Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

order month by recent date

Hi, 

 

I am trying to show rolling last 12 and 24 month in one line diagram. 

On the X axis i want to have month with the last full month on the right. 

 

Somehow I need to order month by recent month.

 

For example now august :

 

X.axis    aug sep okt nov dec jan feb mar apr may jun juli

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    I'd like to suggest you to take a look at following blog to know how to calculate cumulative total:

    Cumulative Total

    For custom order, you can refer to below link to create a custom sort table with 'sort by column' feature to achieve your requirement:

    Custom Sorting in Power BI

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    I'd like to suggest you to take a look at following blog to know how to calculate cumulative total:

    Cumulative Total

    For custom order, you can refer to below link to create a custom sort table with 'sort by column' feature to achieve your requirement:

    Custom Sorting in Power BI

    Regards,

    Xiaoxin Sheng