Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Sonyat810
Helper III
Helper III

Sort by most recent events first?

Is it possible to sort by the most rcent data input? If so, how would this be done?

 

Sonyat810_0-1738155080822.png

 

1 ACCEPTED SOLUTION

hi @Sonyat810 

 

as you can see just simply apply your sorting on year + day

Uzi2019_0-1738155881531.png

 

 

like below or sort the table using 3 dots.

 

Uzi2019_1-1738155915359.png

 

 

I hope I answered your question!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

View solution in original post

11 REPLIES 11
Bibiano_Geraldo
Super User
Super User

hI @Sonyat810 ,

For scenarios like this, i recomend you to use the date instead of date hierarchy, in this way, you will sort the column with just a click:

Bibiano_Geraldo_0-1738156709804.png

 

If you're using date from the calendar table, just make the calendar table as date table:

Bibiano_Geraldo_1-1738156820208.png

 

 

Uzi2019
Super User
Super User

Hi @Sonyat810 

 

You can simply use shift + select column name for multiple level of sorting in table visual not in Matrix viusal.

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

I get this error. 

I’m interested in being able to see what happened in the last x days.

Sonyat810_0-1738156038850.png

 

Hi @Sonyat810 

 

why are you sorting by other column??

 

use visual setting 3 dots > then sort > Asc/Desc

 

Uzi2019_0-1738156282356.png

 

 

I hope this might help...

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

How can I get my days in chronilogical order? I can't sort for boyh year and day for some reason?

 

Sonyat810_0-1738162794414.png

 

Hi @Sonyat810 

 

If you are using table visual then use Shift key + click on column header for ASc and desc sorting .
Hold shift key while applying sort on multiple column.

 

I hope I answered your question!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

hi @Sonyat810 

 

as you can see just simply apply your sorting on year + day

Uzi2019_0-1738155881531.png

 

 

like below or sort the table using 3 dots.

 

Uzi2019_1-1738155915359.png

 

 

I hope I answered your question!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

I figured it out . Thanks

mh2587
Super User
Super User

If its numerical column then yes, If not change the data type


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



How can I do this?

If a text column you need to find the unique numerical column for that and you can use sort by column option.


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.