Forum Discussion
How to fully disable sort on table visual?
I have a table visual, where I am only displaying KPIs, so I wanted to fully disable the 'sort' option.
By "fully disabled" I mean that when the pbix is published, not even letting a user sort it by clicking it... (If the user clicks the column title, it should not sort).
(i am consuming from a ssas tabular, so I dont have a 'Data' view/panel, I only have 'Model' and 'Report')
Anonymous I don't think there is an option to disable sort, what you can do is to add a box on top of the header with transparency as a background color so that users cannot click the heading.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
2 Replies
Anonymous I don't think there is an option to disable sort, what you can do is to add a box on top of the header with transparency as a background color so that users cannot click the heading.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
Hi, Anonymous
As mentioned by parry2k ,it is not supported to disable sorting in a table visual currently.You can create a transparent rectangle shape or button on top of the column headers of the table, and then group it and the table.
You can refer to this related thread.
https://community.powerbi.com/t5/Desktop/How-to-disable-sorting-in-Table-visual/td-p/1240794
You can also vote for this related idea on Power BI Ideas forum. If there are enough votes, the Product Team will evaluate and take good consideration about it.
Best Regards,
Community Support Team _ Eason
