Thank you for posting your query onto the Forum.
Well there’s no direct option or workaround as of now, that one can disable the sorting of any column in a “Table” or “Matrix” visual. But you can definitely apply a trick to prevent your users from sorting any columns unknowingly. Below are the steps suggested alongwith the screenshots provided for the reference -
Steps 1: Under the “Insert” tab. Go to the “Shapes” option and select the "Rectangle" shape.
Step 2: Resize the “Rectangle” shape as per the column headers in your visual.
Step 3: Go to the “Format Shape” pane. And disable the “Fill” option and under the “Line” option bring down the “Weight” from 3 to 0
Step 4: Now, if you check the visual the “Rectangle” shape will be hidden. So if the users by mistake also clicks on to the header instead of sorting the “Rectangle” shape will get activated but they won’t be able to see that shape since we’ve already removed the format of that shape.
So in all I guess this is a good bargain since there’s no other alternative to disable the sorting option by default in Power BI.
I’m also attaching the working of the PBIX file for the reference.
Hoping you find this useful and meets your requirements that you’ve been looking for.
Thanks and Warm Regards,
Income Statement - Harsh.pbix (858.2 KB)