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.