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
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?
Hello Ashish_Mathur , Thank you for your reply. I don't know how to show you the expected result but I can explain you what I'm trying to achieve and I attached the screenshot bellow.
-I want to sort my martice table by the departure time so I can have the ID sorted by the earliest departure time.
-The second thing is that when I choose a specific itinerary on the slicer on the right, I want to have the same order of this itinerary on my matrice table. For example, when I select Kansas/Colorado and then Colorado/Oklahoma, I want to sort the matrice table by this specific order that the user has chosen.
Thank you very much for your help, I appreciate it. Hope you can figure out a way to solve my 2 weeks problem 😪
Regards,
Elois