Re-ordering x-axis according to months

[Anonymous]

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?

[Anonymous · Accepted solution]

@Anonymous - 

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)

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