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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Sorting and Empty Rows in a Table

A few days ago I made a post about sorting months on a barchart. Now I have a similar question about tables.

 

Click HERE to see my probelm. I added the Month Sort Colum to get things to sort the right way, but I would like to not have it seen.

  • Is there a way to hide that column of data so that it doesn't show?
  • Is there a way to sort without this column?
1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

Hi @Anonymous ,

 

You can just try moving this column to the end of the table (as in your screenshot), then try to minimise the width of this column which will hide this column in your table visual.

Also, don't forget to turn off "WORD WRAP" under VALUES section as shown below:

Pragati11_0-1612973924252.png

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , You need mark month sort as the sort column for month , but that need to be month year

 

Month Year = FORMAT([Date],"mmmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

 

mark Month Year sort  as the sort column - https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Pragati11
Super User
Super User

Hi @Anonymous ,

 

You can just try moving this column to the end of the table (as in your screenshot), then try to minimise the width of this column which will hide this column in your table visual.

Also, don't forget to turn off "WORD WRAP" under VALUES section as shown below:

Pragati11_0-1612973924252.png

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

This is an acceptable work around. Microsoft should really make it a feature to be able to hide columns. When you have to add columns to get the sorting behavior you want, the option should exist to hide columns.

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!

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!