Forum Discussion

MalvikaBhasin's avatar
MalvikaBhasin
Helper III
2 years ago
Solved

Line Chart - gone incorrect

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...
Need Help
  • ibarrau's avatar
    ibarrau
    2 years ago

    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

MalvikaBhasin's avatar
MalvikaBhasin
Helper III
2 years ago

Hi,

 

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

 

 

 

 

Regards

Malvika

ibarrau's avatar
ibarrau
Super User
2 years ago

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