Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
@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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@MinCK It sounds like you can benefit from adding a sort column to your table, sorted ascending, then sorting your effective date by that column.
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?
@MinCK You could create another column to sort the effective date column on. Are the effective dates contiguous, or can the same date be on more than 1 row?
Click the ellipsis in the upper right corner of your Matrix visual. There you should be able to sort Descending or Ascending, yes?
Proud to be a Super User! | |
Hi @ToddChitt, thank you for your reply. I am trying to find that too but it doesn't show on my end. The matrix allows me to sort by any row, but not the column itself. I don't mind sorting by any row, what I want is to just sort the date column from to show the latest first not the oldest.
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |