How can i set a default sort by column in tabular report

[Anonymous]

 I am Using a tabular visual in power bi and sorting is not working prpoerly i need to sort by one column by default but as of now it is sorting by another column. i sorted the dataset by my desired column but after loading the visual it also sort same as previous any idea ?????

[Anonymous]

@Anonymous,

Could you please share sample data of your original table and display your desired sort here? In your scenario, please  use sort by column option following the guide in this article.


Regards,
Lydia

[Anonymous]

@Anonymous,

thanks for yourreply i have attached the screen shot of my visual. now by default the visual is 

sorted by column named 'criticality' but actauly it need to be sorted by 'BOP Amount'

[Anonymous]

@Anonymous ,

Does it show your expected result when clicking on sort by BOP Amount in your screenshot? Could you please share sample data of your original table here which can be downloaded? I will test it on my side.

Regards,
Lydia