Chart with timeline (monthly) not following the sequence

[Dunnnnnnnnnnnnn]

Hello, 

 I have an excel with monthly data where I arrange the date (month) in  columns horizontally. Then, I uploaded it into a power bi apps, I unpivot the date columns so that it will read it vertically. However, when I wanted to displayed in a visual, my x-axis (monthly timeline) is not in a proper sequence where the arrangement of month is not in their ways. How I want to ensure the timeline in a appropriate way?

Thank you in advance!

[Ritaf1983 · Accepted solution]

Hi @Dunnnnnnnnnnnnn 
Please refer to my answer in the linked discussion:

https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Matrix-Date-Column-Sorting/m-p/3547366

it includes pbix with an example

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