cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kshah
Frequent Visitor

Re-ordering x-axis according to months

Hi,

 

I am trying to re-order the x-axis of my bar graph with respect to months in the year. The best I could get out of the sort feature was I was able to arrange them alphabetically but that does not help.

 

Second thing, I would like to know if there's a way I can create a standard x-axis (Jan - Dec) because there has been no activity in a few months in my data so there are no values pertaining to it. For example, May, June, and September are missing on the axis. Is there a way that I can have them on the axis but their values are 0?

1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Re: Re-ordering x-axis according to months

@kshah - 

To order by sequential months, you need to have a separate numeric month column, and set the Sort By Column to that number. (This Properties Pane is in the Model View)

Sort By Month Number.PNG

For the second part (which you'll actually need to implement first), you need a Date Table. One option, if you have a date column in your table, is to use that for your x axis. Otherwise, you'll need a separate date table. If you use a separate date table, you'll need to do the following:

1. Find a script to create a date table in M (Power Query Language) or DAX.

2. "Mark as Date Table"

3. Create a relationship with your current table

4. Set up the Sort By described above

 

Cheers!

Nathan 

View solution in original post

1 REPLY 1
Super User II
Super User II

Re: Re-ordering x-axis according to months

@kshah - 

To order by sequential months, you need to have a separate numeric month column, and set the Sort By Column to that number. (This Properties Pane is in the Model View)

Sort By Month Number.PNG

For the second part (which you'll actually need to implement first), you need a Date Table. One option, if you have a date column in your table, is to use that for your x axis. Otherwise, you'll need a separate date table. If you use a separate date table, you'll need to do the following:

1. Find a script to create a date table in M (Power Query Language) or DAX.

2. "Mark as Date Table"

3. Create a relationship with your current table

4. Set up the Sort By described above

 

Cheers!

Nathan 

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors