Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
SM_1997_
Frequent Visitor

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

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?

Power BI Issue.jpg

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @SM_1997_ ,

See the below ,is this what you want?

vluwangmsft_0-1636960746341.png

 

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".":

vluwangmsft_0-1636960988326.png

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

vluwangmsft_1-1636961066535.png

And then sort by "."

vluwangmsft_2-1636961137252.png

 

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


Best Regards

Lucien

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @SM_1997_ ,

See the below ,is this what you want?

vluwangmsft_0-1636960746341.png

 

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".":

vluwangmsft_0-1636960988326.png

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

vluwangmsft_1-1636961066535.png

And then sort by "."

vluwangmsft_2-1636961137252.png

 

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


Best Regards

Lucien

SM_1997_
Frequent Visitor

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?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.