Forum Discussion
Sorting date in column in table visual
Hi guys!
I am working on building table visual on Power BI which has values by date like the example.
However, the date is showing in oldest to newest order, which I want to flip it back to newest to oldest.
I don't see the sorting option when I hover around the column. So, I would love experts' comments on this to solve this issue.
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.
6 Replies
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.
Click the ellipsis in the upper right corner of your Matrix visual. There you should be able to sort Descending or Ascending, yes?
