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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Omesh
Helper I
Helper I

Hi Expert, Disable Sort

How to turn off each column sorting in a table visualization?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi  @Omesh ,

 

Sorry, as far as I know, Power BI is not able to implement this feature for now, because the ability to sort by columns is one of the basic features of the table visual object, and fields are automatically sorted implicitly in the visual object.

If you want to keep the order of the original table, you can add an index column to the original table in PQ and then use the .

vyangliumsft_0-1699432839920.png

vyangliumsft_1-1699432839924.png

Or you can take a look at the link, create a blank button with the size of the table header and place it at the top of the table visualization, then just combine them and the user won't be able to choose the order:.

Solved: How to disable sorting in Table visual - Microsoft Fabric Community

 

You can also vote on these ideas at the following link:

Microsoft Idea

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hi  @Omesh ,

 

Sorry, as far as I know, Power BI is not able to implement this feature for now, because the ability to sort by columns is one of the basic features of the table visual object, and fields are automatically sorted implicitly in the visual object.

If you want to keep the order of the original table, you can add an index column to the original table in PQ and then use the .

vyangliumsft_0-1699432839920.png

vyangliumsft_1-1699432839924.png

Or you can take a look at the link, create a blank button with the size of the table header and place it at the top of the table visualization, then just combine them and the user won't be able to choose the order:.

Solved: How to disable sorting in Table visual - Microsoft Fabric Community

 

You can also vote on these ideas at the following link:

Microsoft Idea

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @Anonymous Thanks, I have implemented using a shape above visual header & group them together 

Anonymous
Not applicable

Hi  @Omesh ,

 

When you select the [ID] column -Column tools - Sort by column -- [Date], as long as you don't select the rest of the column headers in Visual, then Visual will automatically sort by [Date].

vyangliumsft_0-1699423746799.png

vyangliumsft_1-1699423746802.png

Are you referring to a time when you already have a sorting rule in place that doesn't affect the previous sorting rule, even if you select the column headings for Visual? If it doesn't meet your expected results, you can express the results as a picture and we can help you better!

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi @Anonymous Thank you for your reply. I would like to know how I can turn off the sorting feature in a report visualization.

amitchandak
Super User
Super User

@Omesh , Table visual sort on at least one column. when click on the header of another column, it will sort on that

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Yes correct, but I'd like to implement sorting for one column and restrict sorting for others column.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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