Reply
Sonyat810
Helper III
Helper III
Partially syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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!!!

Syndicated - Outbound

I get this error. 

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

Sonyat810_0-1738156038850.png

 

Syndicated - Outbound

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!!!

Syndicated - Outbound

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

 

Syndicated - Outbound

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!!!

Syndicated - Outbound

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!!!

Syndicated - Outbound

I figured it out . Thanks

mh2587
Super User
Super User

Syndicated - Outbound

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



Syndicated - Outbound

How can I do this?

Syndicated - Outbound

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



avatar user

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)