Forum Discussion
Matrix visual - sorting in chronological order rather than alphabetical
Hi Mandi-Holt
Try this function,
Besides, here are two sorting methods for your reference
Change how a chart is sorted in a Power BI report
Sort one column by another column in Power BI Desktop
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.
Hi,
Sorry for the delay in replying. I have looked at the screenshot you provided and there is not the option to sort by the LocationName. I am also unable to sort by another column as there is more than one value in the DailyLogDate (or StartDate or EndDate) for the same value in LocationName.
I have tried to add a table called LocationSort which lists the locations in the order they have been visited during the project, however when sorting by this I then get all the locations I included in the LocationSort table added to each of the days rather than only the locations that were visited on that particular day.
I'm still exploring other options as I learn more about Power BI and hopefully will be able to resolve it at some point.
Any other suggestions will be very gratefully recieved.
Thanks.