How to turn off "sort by another column"?

[Ormesome]

PowerBI Desktop, Version: 2.56.5023.942 64-bit (March 2018)

I have downloaded a pbix file and opened it in PowerBI Desktop. The data source is a PowerBI Service and the lack of Data or Relationship tabs indicates it's a SSAS solution.

When I put some of the data (accounts) into a matrix and sort by the account name it actually sorts by the account number. This leaves the account names in a seemingly random order. I want to confirm that the model is set to sort by another column. Ideally I'd be able to turn this off.

Is there a tool I can use to view the queries? Apparently I can't use DAX Studio because it only works with imported models.

Is there a means of turning off "sort by another column" when I don't have access to the model?

[GilbertQ]

What you could do, is to sort the matrix yourself by clicking on the column name at the top?

Another option is to find out who created the SSAS model and ask them what they used for the Sort by column?

[Ormesome]

Clicking on the menu at the top to sort asc or desc sorts it by the associated field rather than the displayed field.

As you both have suggested, I'm going to have to go back to the original developer.

[Shahfaisal]

I don't think you can do this. The documentation says "You can create report level measures in the Power BI Desktop, but all other query and modeling features are disabled when exploring live data". Can you reach out to the author of the model? 

[Anonymous]

You can go to Power Query Editor->Advance Editor to check the M using to load the data and then modify the Order.

[Ormesome]

How do I get there without access to the Data or Relationships tabs?

[GilbertQ]

You will have to log into the SSAS cube to see this all.

[Ormesome]

Except that it's not my cube. It's a PowerBI Service.

Surely there's a way to say, "that's a great recommendation, but I don't want to sort by that field. Thanks all the same."