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 there,
To save future readers some pain, the other answers given here are not correct and will cause serious problems for you if you need to prevent users from sorting using the column headers. The issue is that even if you group the blank button and the table visual together, if a user clicks somewhere else on the table visual (e.g. to scroll or select a row) the table will become selected and the user will then be able to sort using the column headers.
Luckily, there is a solution if you put the visuals in separate groups. I found a great explanation here: https://www.youtube.com/watch?v=PKIcjGz_Swg
Hi sseverson12,
Since November 202 there is another option that you can turn on in each visualization to maintain layer order so the visualization will keep the order.
Check the explanation in the link below
The video is from the same user that you also shared a link.