Forum Discussion
Helper IIILine Chart - gone incorrect
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=NlX7Cp2P0d4Remember 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
Super UserHi. 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,
MalvikaBhasinHi,
Why am I not getting the option of COLUMN TOOLS to sort month-wise?
Regards
Malvika
- ibarrau
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=NlX7Cp2P0d4Remember 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
- MalvikaBhasin
Hi Ibaru,
I sorted it Week wise, and here still is uneven output in terms of Week.
Regards
Malvika