Forum Discussion
Sorting date in column in table visual
MinCK
Power BI doesn't allow you to sort the column in a matrix viz, following work around should work for you.
I added a new column in Power Query to rank the date column in descending order witch later will be used to sort the date column when loaded to Power BI using sort by column.
New rank column in Powr Query:= Table.AddRankColumn(#"Renamed Columns", "DateOrder" , { "Date", Order.Descending })
Apply Sort by column:
You get the dates sorted in decending order:Note: whereever you use this date column, the order will be decesnding. You may duplicate the date column and use only for this viz if no other modeling concerns arise.
Thank you bchager for the fast reply, do you mean adding a sort column in the semantic model? I tried using other column to sort it. However, it has no option for me to adjust the ascending or descending order. Or do you think I should create another column specfically for sorting this?
