cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NewB2PowerBI Frequent Visitor
Frequent Visitor

Unable to sort the Date Column in Descending order like I can in an Excel Pivot

Hello,

 

User/company preference is to have the Date field in the column and have it sorted in Descending order.

I am able to do this in an Excel Pivot and Google Docs Pivot, but I can't figure our how to do it in Power BI.

 

Screen shot below is how it appears in an Excel Pivot Asscending, preferred Descending and the default Power BI in Ascending order. The Question is, how can I change Power BI to Descending order.

 

Screen Shot 2018-07-02 at 2.45.48 PM.pngPower BI default Ascending order that I want changed to Descending order.Screen Shot 2018-07-02 at 2.42.33 PM.pngPivot Default Ascending order that I want changed to DescendingScreen Shot 2018-07-02 at 2.43.11 PM.pngPivot Date Descending order that I prefer

1 ACCEPTED SOLUTION

Accepted Solutions
rajendran Super Contributor
Super Contributor

Re: Unable to sort the Date Column in Descending order like I can in an Excel Pivot

8 REPLIES 8
rajendran Super Contributor
Super Contributor

Re: Unable to sort the Date Column in Descending order like I can in an Excel Pivot

Hi

 

You can sort in Data tab -> Select the column -> Right click on the column header -> Select descending/ asending sorting as you need. We can do the same in Query Editor too.

 

I hope this is what you are looking for.

 

Thanks
Raj

NewB2PowerBI Frequent Visitor
Frequent Visitor

Re: Unable to sort the Date Column in Descending order like I can in an Excel Pivot

THank you for the reply. I tried the following, but it still doesn't work.

"You can sort in Data tab -> Select the column -> Right click on the column header -> Select descending/ asending sorting as you need. We can do the same in Query Editor too."

rajendran Super Contributor
Super Contributor

Re: Unable to sort the Date Column in Descending order like I can in an Excel Pivot

Right click on the right top of the visualson the eclipse (...) symbol and do the sorting as needed from the options.

 

Thanks

Raj

NewB2PowerBI Frequent Visitor
Frequent Visitor

Re: Unable to sort the Date Column in Descending order like I can in an Excel Pivot

Can you send a screen shot, I dont know what you're referring to.

rajendran Super Contributor
Super Contributor

Re: Unable to sort the Date Column in Descending order like I can in an Excel Pivot

Sorting.PNG

NewB2PowerBI Frequent Visitor
Frequent Visitor

Re: Unable to sort the Date Column in Descending order like I can in an Excel Pivot

Yes, what I meant was that I did this and it didn't work. My date column still only sorts ascending.

rajendran Super Contributor
Super Contributor

Re: Unable to sort the Date Column in Descending order like I can in an Excel Pivot

ropebender Frequent Visitor
Frequent Visitor

Re: Unable to sort the Date Column in Descending order like I can in an Excel Pivot

I have a two-column sort issue.  I have a date-time column, and a "Ticket Number" column.  I want to group all the ticket numbers together, but have them in date-time order, so I know the order of functions applied to each ticket.

 

I can sort by Date, and all the dates are in order, then I try to sort by Ticket number, and the ticket numbers are in order -- but the date/time order is mixed up.  In Excel, if I do this the date order remains sorted within each ticket number.  I can do sorts on multiple columns and the old sorts remain for each new grouping.  I can't get this to happen in Power Pivot (Excel 16)

5/19/2019 12:46:00 PMINC000007156403
5/22/2019 7:25:00 AMINC000007156403
5/22/2019 7:27:00 AMINC000007156403
5/19/2019 12:56:00 PMINC000007156403
5/22/2019 3:15:00 PMINC000007156403

Can you help? 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 329 members 3,088 guests