Hello! I was following the Income Statement tutorial led by Sam and was able to sort the income statement by the “Row Index” hidden column which works fine. However, if the user accidently clicks on any other non hidden column headers on the income statement, it would automatically reorder based on that column (see below image). Is there a way in Power BI to disable the column reordering or freeze the ordering by only allowing it to sort by only “Row Index” column?
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 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.
