cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Re: how to sort Date (MonthYear column)?

Hi @tringuyenminh92,

 

Tried setting up the Sort by Column but my table and charts still didn't sort properly.  I followed the steps and the YearMonthInt formula worked. What am I missing?

YMI.PNGChart.PNGTable.PNG

 

Highlighted
Advocate III
Advocate III

Re: how to sort Date (MonthYear column)?

An elegant solution is to create a date bin. You do this by

 

  1. Right click on data field (make sure it's a date type)
  2. Select 'New Group'
  3. Create Bins (could be more than one month if you wish)
  4. choose the new bin for your 'shared axis' in the Report View
  5. win

bins.screencap.png

Highlighted
Helper II
Helper II

Re: how to sort Date (MonthYear column)?

And remember to check that your date column is well based on "DATE" type otherwise it may not work 

Highlighted
Regular Visitor

Re: how to sort Date (MonthYear column)?

 This worked for me!  Thanks!

Highlighted
Anonymous
Not applicable

Re: how to sort Date (MonthYear column)?

Thanks it worked for me.

Highlighted
Kudo Collector
Kudo Collector

Re: how to sort Date (MonthYear column)?

Worked for me so thank you @tringuyenminh92 

Highlighted
New Member

Re: how to sort Date (MonthYear column)?

this worked for me

Highlighted
Advocate I
Advocate I

Re: how to sort Date (MonthYear column)?

Wow, I'd been looking what felt like everywhere for an answer to this problem, somehow no other site or video suggested that trick of multiplying the year by 100, that's what made it work for me. More than three years after you wrote the post, too. Thanks!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors