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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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