Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

 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 ?????

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@v-yuezhe-msft,

 

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'

 

 

Tabular.png

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.