Forum Discussion
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...
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
Hi Ibarru,
I tried modelling and sorting BUT data is not getting sorted by Weeks/Months instead by Revenue.
Regards
Malvika