Reply
Dunnnnnnnnnnnnn
New Member
Partially syndicated - Outbound

Chart with timeline (monthly) not following the sequence

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?

 

Dunnnnnnnnnnnnn_0-1702435142457.png

 

 

Thank you in advance!

 

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Syndicated - Outbound

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

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Syndicated - Outbound

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

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)