Forum Discussion

Mandi-Holt's avatar
Mandi-Holt
Frequent Visitor
4 years ago

Matrix visual - sorting in chronological order rather than alphabetical

I am new to Power BI and have been trying to sort in a Matrix visual. The visual I am trying to create has the durations of operations carried out by a vessel split by the date and the location the ...
Need Help
  • Mandi-Holt's avatar
    Mandi-Holt
    Frequent Visitor
    4 years ago

    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.