Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dmarques
New Member

Change order of a chart to display like it is on excel (monthly order)

Hi,

I'm new to PowerBI and trying to create my first visuals.

I have some data on an excel which I imported over to PowerBI that shows some data monthly. On excel the months are ordered how I wrote them, but when I imported over to PowerBI, it was readjusted by alphabetically order.

Is there a way to show the data as it's ordered on the excel?
Thanks

1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

Hello @dmarques ,

In your table add a column that shows month number then sort the month column with the month number column.

Idrissshatila_0-1673274580776.png

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

 

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

1 REPLY 1
Idrissshatila
Super User
Super User

Hello @dmarques ,

In your table add a column that shows month number then sort the month column with the month number column.

Idrissshatila_0-1673274580776.png

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

 

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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