Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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!
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    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:

    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.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, Anonymous 

 

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:

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.