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
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |