Line Chart - gone incorrect

[MalvikaBhasin]

Hi,

Below is my data for which I want to create line chart. 

However, the line chart I created is showing months in an incorrect manner - neither ascending or descending. 

Can you guide how can it be corrected?

[MalvikaBhasin]

Hi Ibarru,

I tried modelling and sorting BUT data is not getting sorted by Weeks/Months instead by Revenue.

Regards

Malvika

[ibarrau]

Hi. In order to let power bi understand that the order of the months is not alphabetical, you must have the number of the months to specify the order. You can do it adding a column or creating the calendar table and relate it. Check this example of how to order by other column:

https://community.fabric.microsoft.com/t5/Desktop/How-to-get-line-chart-sorted-by-month/td-p/3241078

I hope that helps,

[MalvikaBhasin]

Hi Ibaru,

I sorted it Week wise, and here still is uneven output in terms of Week. 

Regards

Malvika

[MalvikaBhasin]

Hi,

Why am I not getting the option of COLUMN TOOLS to sort month-wise? 

Regards

Malvika

[ibarrau · Accepted solution]

Like the link I have sent, you must add a column with the number of the month. You can build a logic checking the name of each month in order to set the number. This video might help.
https://www.youtube.com/watch?v=NlX7Cp2P0d4

Remember you can add a custom column at Power Query or DAX to build the IF or Switch logic for mapping the months.

I hope that make sense