Forum Discussion
Different date sorting in matrix
I have a report with a graph of performance over time sorted oldest to newest date which is exactly as required. On the same report I have a matrix showing some of the detail from the report and the...
v-piga-msft
Resident Rockstar
Resident RockstarHi @PaulWeaver,
Column sort in Matrix visual is not supported in Power BI currently, please vote this idea here which has been submitted in Power BI ideas forum.
For the workaround, you could try to add a custom column in Power Query, then sort by this column. You could refer to the steps below.
1. Edit Queries—— Add Column——Duplicate Column——Change the column type to whole number
2. Add a Custom column —— Close & Apply
3. Sort saledate by Custom
4. You will get your expected matrix visual like below.
Best Regards,
Cherry