cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gokul Member
Member

sort the date

2.png

how to sort the measure (AvgTurnAroundTimeForTask) ???

14 REPLIES 14
themistoklis New Contributor
New Contributor

Re: sort the date

On the top right of the table object there are 3 dots.

Click on that one and there is an option to sort the data

Highlighted
Gokul Member
Member

Re: sort the date

as u said it will sort based on the decimal number only...I already sorted based on what u said..

Eg:after 8days next one will be 7hrs.. 

themistoklis New Contributor
New Contributor

Re: sort the date

@Gokul Best to send us a sample of the workspace.

You mentioned decimal but i cant see it on the posted image

Gokul Member
Member

Re: sort the date

@themistoklis thanks for ur reply..AvgTurnAroundTimeForTask is a calculated measure which converts minutes to day hr mins ...i want to sort based on "day hr mins" Format..

themistoklis New Contributor
New Contributor

Re: sort the date

@Gokul

 

Will be difficult to tell you what's going on if we cant see the objects on the workspace... mask any sensitive data

Gokul Member
Member

Re: sort the date

2.png

avgTurnaroundTime is an calculated measure..i want to sort avgTurnaroundTime in descending order   such that it will be as 9 Days 23 hrs 59 mins and then next with 9 Days 22hrs 55mins..

themistoklis New Contributor
New Contributor

Re: sort the date

@Gokul

 

I have replicated your data and it works ok on my workspace.

 

2 Steps to do:

1. Click on the three dots --> Sort by --> Select AVGTurnaroundTimeforTask

2. Then Click on the three dots and select Sort descending

Community Support Team
Community Support Team

Re: sort the date

Hi @Gokul,

 

Have you solved your problem with the suggestion from themistoklis?

 

If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

In addion, is your measure a text type, if it is, I'm afraid that we may not sort the measure directly in Power BI.

 

There are two workarounds you may have a try.

 

1. Change the measure to calculated column and use the feature Sort by columns. You could refer to this similar thread.

 

2. Split your measure with Day and time, we could sort time and whole number type in Power BI.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Gokul Member
Member

Re: sort the date

Hi @v-piga-msft @themistoklis

i have added other column (ie) average turnaround time in minutes ....and i turned off the word wrap in column headers and sorted according to that(average turnaround time in minutes) ....

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 46 members 810 guests
Please welcome our newest community members: