Forum Discussion

wasikazmi's avatar
wasikazmi
New Member
1 year ago
Solved

Jul to June Sorting

Hi, I want to sort my slicer from July to June using sort by column but still is order is weird. Please help me out to sort months starting from July and Ending to June.

 

 

  • So you sorted the month column by fiscal month in the Column Tools, right? But your fiscal month is obviously a string, make it a number. It is a string and it goes July-1, then April-10, May is 11 and June is 12. If you change it to an integer it will fix the problem.

1 Reply

  • olgad's avatar
    olgad
    Resident Rockstar

    So you sorted the month column by fiscal month in the Column Tools, right? But your fiscal month is obviously a string, make it a number. It is a string and it goes July-1, then April-10, May is 11 and June is 12. If you change it to an integer it will fix the problem.