Re: disable sort on a visual - a workaround

John4Roberta · ‎09-18-2020

Insert a box in front of the visual(s). Make the box invisible - zero width line and no fill.

In order to hide the sorting arrows I place another small box on top with the same colour as the column header.

This is a workaround until that option becomes properly available.

AllisonKennedy · ‎09-18-2020

Awesome workaround. That drives me crazy all the time! Have you voted for the feature update on Power BI ideas too? https://ideas.powerbi.com/ideas/idea/?ideaid=c66eaa0d-ed3b-44a3-b600-c867e2c1863f

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

John4Roberta · ‎09-18-2020

Hi Alison

Tried to vote there but not able!

Anyway, I did post my suggestion there as well, so that my help others.

Thanks

AllisonKennedy · ‎09-18-2020

Strange you can't vote? I can see your comment there though so hopefully that helps others in the meantime.

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

disable sort on a visual - a workaround