Forum Discussion

Niki's avatar
Niki
Icon for Helper III rankHelper III
7 years ago
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 ...
Need Help
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    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.

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
7 years ago

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

  • Niki's avatar
    Niki
    Icon for Helper III rankHelper III
    7 years ago

    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.