Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to 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 , 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
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
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.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |