Sorting x-axis doens't seem to work (months)

[Anonymous]

Hi all,

First of all I want to say I've watched recent posts & vids (guy in a cube) about this matter, but somehow it doesn't work for me.

Could be I'm using a different version or maybe because of the Dutch version.

The problem: I'm trying to make the X-axis go normal Month based (Janaury to December).

Yet decending ar ascending order doesn't seem to work.

In my data sets I have created the colomns below and connected the ETD Maand (month) with the other data set.

Omschrijving = Description of the Month

And secondly I've selected the 'omschrijving' colomn and changed the sort by colomn to 'ETD month'.

So after this I expected the Months to sort normally (like happened in the vid) but nothing happens.

What steps am I doing wrong in here?

Thanks for the help in advance!

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

Does the X-axis on the column chart come from the date column of your fact table or from the sort table (with columns ETD Maand and Omschrijving)?The X-axis on the column chart should use the Omschrijving column of the sort table for the sort function to work just as shown in below screenshot... Please find the details in the attachment.

Best Regards

[Anonymous]

This was exactly where the fault was.

Thanks!

[amitchandak]

@Anonymous , Make sure it saved properly and then in visual make sure from three dots it sorted on month and order is also correct