Kanika Soni on 14 Sep 2021 08:14:36
currently we can not sort matrix data on column basis. Is this possible to do similar excel like column sorting in Power BI?
- Comments (3)
RE: Matrix sort on column headers
I was surprised when you cannot sort a Matrix by multiple columns. You would think it is basic functionality to shift click column headers to multi-sort.
RE: Matrix sort on column headers
This is astounding missing functionality. Why didn't the person who made it possible to sort rows spend a few extra minutes to provide the same functionality for columns? Instead thousands of Power BI users have to adjust tens of thousands of data sources to provide this functionality. In Analysis Services, for every single field in every single database you need sorted descending, you have to add TWO columns, one to copy the original data that is sorted ascending and a second to create a descending sort field that you apply to the first! Amazing....
RE: Matrix sort on column headers
This is definitely a fundamental missing functionality. Please consider updating Power BI. Thanks.