Solved: Re: How to disable sorting in Table visual - Page 2

Anonymous · ‎07-22-2020

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.

Anand24 · ‎08-05-2020

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 !!!

View solution in original post