cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kshah Frequent Visitor
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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors