Barcharts not representing in correct month order

[Aslam]

Hi,

Can anyone help me,

My aim to get my bar diagram in a correct order( November 2021data should be left side and the latest data in right hand side).

My created time table data format is DD/MM/YY HH:MM:SS , However i just used only year and month

This is a line and cluster coloum chart

[amitchandak · Accepted solution]

@Aslam , You should expand in that case so that year stays with the month and it gets sorted first by year and then a month. Seem like you have to use the next level 

or create a date table with month and year with the correct sort column(mark that as a sort column) and use that

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c