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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

How to sort my data by by months starting with January

I read through several postings but they weren't helpful. I attached a photo of my bar chart and my question is how to arrange my X axis by month starting with January - December? I just can't figure that out.  Thanks PBI.PNG

 

3 REPLIES 3
EugenioJunior
Frequent Visitor

Hi @Anonymous 

 

You need to create an index column for each of the months.

Then you can click on your month column and go to the modeling tab and select the index column to sort the months.

Anonymous
Not applicable

i do not know what you mean by creating an index column for each month? I already have the 1 months listed in the Months field data

Within your data, do you have a date field? If so create a new column from this field that extracts just the month e.g.

 

MnthNmbr = Month(your data field)

 

As per the post above, you can then use this field to sort by. To do this, select your date field and then choose modeling > Sort by Column > Select MnthNmbr or whatever you call it.

 

I believe the best practice is to have a query containing all dates (Calendar) and include columns on your calendar that you may wish to sort/summarise by.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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