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 ,
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 !!!
Sad that sorting capabilities in Power BI is so clumsy and ineffective that we have to resort to these measures to simply lock a column's sort order from modification.
Hi,
Thanks for sharing this method. It works great for two of my matrix tables. But it doesn't seem to work on my third one, which has a lot of columns and I need to use horizontal scroll bar to go to the very end on the right.
Do you have suggestion on how to have it work on a matrix report that has a lot of columns with horizontal bar enabled?
Thanks.
Hi Anonymous
The option is still the same only thing you need to garatee is that the shape fills all the wide of the table what I usually do is to create a shape a little large so if the table has 200 of wide I would do the shape with 205 for example.
Thank you MFelix,
It looks I have to cover the scroll bars for it to work. But I need to be able to scroll from left to right.
