Forum Discussion
Solved
matrix column header sort DESC!!
Hi all, Going crazy! So hope any one can help. I have a column with dates which are the matrix column series. I want the most recent date to show up first, but it seems microsoft is recognizing ...
What is your data source? If it is SQL, then you could add a Rank column while importing the data to tabular model:
Rank() over(order by settlementdate DESC) AS DateSort
Afterwards, you could sort Date column by this DateSort column.
I haven't tried to sort the column header but maybe you can sort you table desc then add an index column in power query then sort you date column by index
Hi,
That does not work because it will give an error on circular dependency (first creating an index column based on column A and then try to sort column A by that index column..).
Also sorting from tabular is not kept in the power BI report, it recognizes the date format and puts it ASC, no matter how I formatted the original table in the model.