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

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. 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


✔ 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
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

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.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

March Power BI Update Carousel

Power BI Community Update - March 2026

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