cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Disable sorting in Table

Hi there!

 

Is there a way of making a table in Power BI "static" or basically disable sorting?

 

Thank you in advance!

1 ACCEPTED SOLUTION
Microsoft
Microsoft

Hi, @Arual123 

 

Fields are automatically sorted implicitly in visual. 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 it in visual, which is equivalent to disabling this function.

Like this:

4.png

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

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

2 REPLIES 2
Microsoft
Microsoft

Hi, @Arual123 

 

Fields are automatically sorted implicitly in visual. 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 it in visual, which is equivalent to disabling this function.

Like this:

4.png

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

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

Super User IV
Super User IV

@Arual123 , You can disable, visual header in desktop and that will not show the three dots menu in the power bi service. Option in three dotes will go away. But I doubt that will stop click and sort.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors
Users online (1,418)