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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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

 

 

Is this post help you? Please consider to:

Accept as Solution!
Give a Kudo
Follow me on Linkedin

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.