Forum Discussion

ryoungWH's avatar
ryoungWH
New Member
2 years ago
Solved

Datamart issue - Sorting 1 column by another

I have a powerbi dashboard which connects to a datamart in our app.powerbi.com area. I have a table on there with dates on it that is sorted in descending order with another field that has the longd...
Need Help
ryoungWH's avatar
ryoungWH
New Member
2 years ago

Hi Amit

Thanks for coming back on this - I presume you mean the sematic model online? I can't find an option for sorting the table on a particular field. I can create an exploration and seem to be able to sort it as I want, but is that the same as the datamart?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ryoungWH ,

Consider turning the connection to DirectQuery mode (lower right corner of the desktop) and sorting by another column:

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group