How can I make the table visual sort the way I want it to?

[SM_1997_]

Hello,

I've been having issues getting this table to sort the way I want it to. With the way the data needs to be displayed, nothing can be sorted alphabetically and the empty cells need to stay the way they are. Is there any way at all I can get this data to display the proper way without the use of an index column showing in the visual?

[v-luwang-msft · Accepted solution]

Hi @SM_1997_ ，

See the below ,is this what you want?

Unfortunately, though, if you want to sort in the visuals, you have to have something to base it on, so you have to add index to the visuals. But we can perform some operations to hide the columns until they are invisible.

double click index,raname the column name".":

Click and hold on the red line below and move to the left to hide the column：

And then sort by "."

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[SM_1997_]

Another good way I could sum up my question is to ask if there's any way I can bypass the sorting for the table visual?