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

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join 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
Uzi2019
Community Champion
Community Champion

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
Community Champion
Community Champion

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!!!
Uzi2019
Community Champion
Community Champion

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


✔ Answered? Mark as solution

Muhammad Hasnain | Super User • Fabric • Power BI • Data Engineering

Let's connect on LinkedIn

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.


✔ Answered? Mark as solution

Muhammad Hasnain | Super User • Fabric • Power BI • Data Engineering

Let's connect on LinkedIn

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

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

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.