Forum Discussion

Daemetius's avatar
Daemetius
Icon for Helper II rankHelper II
9 years ago
Solved

How to sort months axis in graph like in query table?

Greetings,   So I have an issue where the months are sorted apparently by name from A-Z in the X-axis of the graph in the picture. Then there's the query table of how they are aligned accordingly. ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Daemetius

     

    According to your description above, you should be able to follow steps below to sort the Months column with April starting out and then May, June, July, August, September, October, November, December, January, February, March in your scenario.

     

    1. Add an Index Column under Query Editor > Add Column tab > Index Column. And click Close&Apply under Home tab.

     

     

    2. Select Months column, click Sort by Column and select Index.

     

     

    Then the Months column will be sort properly. :smileyhappy:

     

    Regards

  • Daemetius's avatar
    Daemetius
    9 years ago
    v-ljerr-msft wrote:

    Hi Daemetius

     

    According to your description above, you should be able to follow steps below to sort the Months column with April starting out and then May, June, July, August, September, October, November, December, January, February, March in your scenario.

     

    1. Add an Index Column under Query Editor > Add Column tab > Index Column. And click Close&Apply under Home tab.

     

     

    2. Select Months column, click Sort by Column and select Index.

     

     

    Then the Months column will be sort properly. :smileyhappy:

     

    Regards

    What I did was add a date column with mm/dd/yyyy format, for example March 1, 2017 and that also solved it.

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Daemetius

 

According to your description above, you should be able to follow steps below to sort the Months column with April starting out and then May, June, July, August, September, October, November, December, January, February, March in your scenario.

 

1. Add an Index Column under Query Editor > Add Column tab > Index Column. And click Close&Apply under Home tab.

 

 

2. Select Months column, click Sort by Column and select Index.

 

 

Then the Months column will be sort properly. :smileyhappy:

 

Regards

Daemetius's avatar
Daemetius
Icon for Helper II rankHelper II
9 years ago
v-ljerr-msft wrote:

Hi Daemetius

 

According to your description above, you should be able to follow steps below to sort the Months column with April starting out and then May, June, July, August, September, October, November, December, January, February, March in your scenario.

 

1. Add an Index Column under Query Editor > Add Column tab > Index Column. And click Close&Apply under Home tab.

 

 

2. Select Months column, click Sort by Column and select Index.

 

 

Then the Months column will be sort properly. :smileyhappy:

 

Regards

What I did was add a date column with mm/dd/yyyy format, for example March 1, 2017 and that also solved it.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Greg_Deckler,

     

    Great to hear the problem got resolved! Could you accept helpful replies as solution to help others who may also have the similar issue easily find the answer and close this thread? :smileyhappy:

     

    Regards