How to fully disable sort on table visual?

[ovonel]

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')

[v-easonf-msft]

Hi, @ovonel 

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

[parry2k · Accepted solution]

@ovonel 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.