Hide column in table visualization that has the purpose of ordering rows

[Anonymous]

Hello everyone, 

I have a column that is used only to respect an order of how the categories should be displayed. 

I know that i can use ToolTips in Stacked Column Charts in order to sort by a certain field (even if it is not displayed in the chart), but i can't find how to do that in a Table visualization. 

If i try to hide it by dragging the table to minimum, it will create larger rows which looks kinda odd. So that's not an option. 

Are there any solutions to this? 

Thank you very much, 

Ovidiu

[Anonymous · Accepted solution]

HI @Anonymous ,

Unfortunately, current you can't hide columns which you used in visual, maybe you can refer to the following link to setting custom sort order of specific column:

Custom Sorting in Power BI  

Regards,

Xiaoxin Sheng

[Anonymous]

Thank you very much, I assumed that's the case but wanted to have a confirmation as well. 

Have a lovely day!