Forum Discussion
How to disable sorting in Table visual
Hi Anonymous ,
MFelixgave a wonderful work-around and that should probably suffice your requirement.
You just need to follow below steps:
1. Create a blank button or blank rectangle
2. Place it over the Table columns (Make sure you place the blank button/rectangle infront of table)
3. Group them together
I'm not sure if you are using table visual or matrix visual but anyway, the drlling options at top right of visual box will be visible to you and you should be able to drill.
With this work-around, you won't be able to perform any operations that are supposed to be related with clicking the table/matrix headers such as sorting in table/matrix and right click -> Drill in matrix.
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
Hi Anonymous ,
This will sort the column but won't solve the issue for the lock of the sort since if your user click on any other column of the table or matrix it will resort by that specific one, and then if the user wants to revert back to the previous sorting then they can't because they will not see the index column.
Thank you. Yes I am finding this out now. I am doing an internship using Power BI in the final throes of my degree, so I am still learning, on my own. I had it working for one table but not the other. In fact for the one that worked I later discovered I had the index column still there but literally hidden from view, as in it went off the page on the right side. Don't know if there's a way to lock the sort. There is no reason for users of my report to be able to sort. But anyway I may be publishing as a pdf on a website, it's quite simply a monthly publication for the local council, river flow rates in order of importance, so my method may work for that. I haven't found the rectangle overlay method to work just yet. Anyway I have more important things to focus on for now.