Graphing data in month/month no order

[Raewynd123]

Hi,

I am very new to this community and working my way through all the guided learning and have a couple of questions about producing graphs in Month order.

When I sort my graph on Month No. to get it into Month order - it doesnt work - it comes up like this....

so then I asked a question in Q&A to see if I could work out what was going on with the Month no format which is currently set to 'Whole Number', and it did this....

am I correct in thinking that it has to do with the format of Month no? and if so, what should it be, because I've tried nearly all of them with no success.

A LOT of the reporting I have to do is dependent on Month and year order so this is really important for me to resolve.

Looking forward to any help you can offer.

Rae 🙂

[blopez11]

Not sure if you're using a Date table, but the month number associated with the month name should be a number (whole)

You can set this in the data model, and selecting the month number column

Then in the report view, select the month name, and select to sort by month number

There are many posts on this subject

Hope this helps 

[Raewynd123]

Hi blopez11 - thanks for your response.

I've tried all that and its still not working.  I think I've missed something along the way.  will keep looking for the solution.

Have a great day 🙂

[v-ljerr-msft]

Hi @Raewynd123,

If you have done the steps blopez11 mentioned above, then month should order correctly.

Could you share a pbix file which can reproduce the issue in your case? You can upload it to OneDrive or Dropbox and sent me the link in private message. Do mask sensitive data before uploading.

Regards

[Raewynd123]

Hi JerryLi,

thanks so much for looking at this.  I have tried all sorts of things to get it to work, with no success.

Link to my data

Regards

Rae 🙂

[v-ljerr-msft · Accepted solution]

Hi @Raewynd123,

I just recreate the chart like yours without doing anything else on the pbix file you shared with me, and the Month orders correctly.

Could you try recreating a new chart to see if the Month orders correctly? Here is the pbix file I used for test.

Regards

[Raewynd123]

Hi JerryLi,

what I just realised is that when I am creating views that need to be in date order - I have to drag the date field (in this case the Month) out onto the canvas first.... and then it graphs it in Month order.

Rookie mistake I guess 🙂

Thanks so much for your willingness to help - I really appreciate it. 

Rae 🙂