Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to disable sorting in Table visual

Hi,   I want to disable sorting on power BI table visual.By default table needs to be sorted based on first column. How to achieve this?please help.
Need Help
Tips and Tricks
Tutorial Requests
  • Anand24's avatar
    Anand24
    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 !!!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for your response.I have applied drill through in that table so will it work once i group button and table that if right click on any row it will drill through to next page? and also i have multiple columns in table so i need to scroll the table.

MFelix's avatar
MFelix
Super User
6 years ago

Hi Anonymous ,

 

I'm not sure about what answer you are refering to, but my answer of creating a button on top of the table will not disable the drilltrough and the scrolling since you should only place the button on top of the headers so to stop the users from clicking the header the scrolling is on the bottom and the drill trough should be made on a cell of the table so everything should work as expected.