Line chat not display the month in sequential order

[Mar2]

Line chat not display the month in sequential order link Jan,Feb, Mar…. and my Axis type is Continuous. Any suggestion please

[Anonymous · Accepted solution]

Hi @Mar2 ,

You can check 'Show items with no data'.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Mar2 , when you have column like

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

you need to create a sort column, and mark that as sort column for last column
Month Year sort = FORMAT([Date],"yyyymm")

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Mar2]

Here my Date column is in hierarchy as below , not a sepearte month column