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
Super User I
Super User I

Re: how to sort Date (MonthYear column)?

Worked for me so thank you @tringuyenminh92 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors