Rank Order in Table

[allenpee85]

Dear Community,

On the Left, the table has sort starts from A1, A2.....

On the right, in fact, can i get something like this? Starts with Aa1, Aa2....

Thank you.

[V-pazhen-msft]

@allenpee85 

Currently, there is no way to hide the column. I suggest you could vote the ideas and add comments to improve Power BI and make this feature coming asap.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/30945430-hide-show-column-on-tabl...

Paul Zheng

[amitchandak]

You need to create a custom sort column and mark that as the sort column

[allenpee85]

Dear @amitchandak ,

Thanks for the suggestion.

I did the "Sort by Column" function.

In the table visualization, I have included the newly created "Custom Sort Column" in order to make it works.

However, is it possible to exclude/hide the "Custom Sort Column" from the table visualization?

Thank you.