Forum Discussion
How to disable sorting in Table visual
- 6 years ago
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 ,
You just need to cover the headers of the table no need to cover the scroll bar has you can see below I have left the border blue so that you could see the shape is until the scroll bar but not touching it and it's only on headers.
I know what is happening. I opened Selection pane. So if I directly click in the button covered area, in the selection, it shows I clicked on Group (Name) or Button. Then it is not impacting sorting. But as soon as I clicked on scroll bar, in the selection pane, it shows Matrix being selected and the sorting is then impacted.
In order not to impact sorting, I would need to move my cursor to select either Group name or Button after I click on scroll bars.
- MFelix3 years agoSuper User
HI Anonymous ,
Forgot to mention one option that you need to have selected in the option that is maintain layer order.
Be aware that this workaround is for the service, on PBI desktop the workaround will not work because you are on editing mode.
- Anonymous3 years agoNot applicable
Thanks MFelix, will keep it on mind 🙂