Forum Discussion
Sort by time
Hello all,
I found a solution for this and it seems to be the right one for now, so I am sharing it with you in case somebody has the same issue .
-To sort by time, I created a new column where I turned hour into second, I added it to my visual, I selected sort by second and then I hide it from my table.
-To sort my table by geographical order, I created a new column where I multiplied longitude x latidude, I added to my table and I sorted by the result of this new column.
Thank you all for your time and help
Kind regards,
Elois
Hi elois33
Thanks for reaching out to us.
if you want to sort table by departure, you can hover over here and click on the triangle icon
if you want to sort table by departure and ID, you can create the measure below,
rank = RANKX(FILTER(ALL('Table'),'Table'[ID bus]=MIN('Table'[ID bus])),CALCULATE(MIN('Table'[departure])),,ASC)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Thank you v-xiaotang and Ashish_Mathur
I wanted to share with you the dashbord but it says that the file type pbix is not supported, so Iam attaching a screenshot. 😕
-You have a matrice table with departure/arrival hours, weight/lenght of cargo, days, ID mission and itinerary. You have also a slicer which allows my colleuges seach for the itinerary they need.
-I'm trying to sort my matrice table by the departure time, so when I have more than one mission for the same itinerary I will have all the missions starting from the earlier one.
-The second thing that I was asked to do and I'm struggling is to sort my table based on the order of the selected value on the slicer. For example when I search for Kansas/Colorado and Colorado/Oklahoma I want my matrice table to have that specific order and not put the itineraries by default in alphabitical order. I have a lot of missions and itineraries and the order of the itineraries is based on my colleuges needs. 😕 I know that maybe with "selected value" I could make things work, what do you think?
Thank you very much for your time and help, it's much appreciated
Kind regards,
Elois
Sharing a screenshot does not help at all. Share a dataset to work with (a table that can be pasted in MS Excel) and on that data, show the expected result.
Hello Ashish_Mathur, thank you for your response.
Please find bellow the link to my power bi file on google drive. Hope it works
Regards,
Elois
https://drive.google.com/file/average_filtered_by_categories
You have not shown the expected result. What result are you expecting?
