Forum Discussion
Restrict table to change sorting
Hi guys,
If I have table visual, can we restrict the column header not to be clicked and change the sorting ?
Coz, I create a table that listed my rank data, I don;t want someone click other column or even on that rank column so it is change order sorting.
Thanks,
Hi Anonymous
I'm afraid that it is not supported to disable sorting in a table visual currently. Here is an idea about this which you could vote for: Microsoft Idea · Disable table column header sorting (powerbi.com)
One workaround is to create a transparent rectangle shape or button on top of the column headers of the table, and then group it and the table. This will effectively disable the clicking option on those column headers.
There are detailed steps about this in this link, or you could also watch this video from around 41:50 onwards.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
1 Reply
Hi Anonymous
I'm afraid that it is not supported to disable sorting in a table visual currently. Here is an idea about this which you could vote for: Microsoft Idea · Disable table column header sorting (powerbi.com)
One workaround is to create a transparent rectangle shape or button on top of the column headers of the table, and then group it and the table. This will effectively disable the clicking option on those column headers.
There are detailed steps about this in this link, or you could also watch this video from around 41:50 onwards.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.