Sorting and Empty Rows in a Table

[Anonymous]

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?

[amitchandak]

@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

[Pragati11 · Accepted solution]

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:

Thanks,

Pragati

[Anonymous]

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.