Matrix Axis - Change Order

[HenryJS]

Hi all,

Is it possible to sort data in a matrix from newest to oldest?

Opposed to oldest to newest - as shown below.

thanks,

[v-kelly-msft]

Hi  @HenryJS ,

Have you checked the suggestion by @amitchandak ?Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[HenryJS]

@v-kelly-msft  I haven't been able to change the order yet. Is there a simple way to do this within Power BI?

[v-kelly-msft]

Hi @HenryJS ,

Sorry for the late reply!

First create 2 columns as below:

DateNumber=DAY('Table'[Dates])

Rank= MAX('Table'[DateNumber])-'Table'[DateNumber]

Then duplicate the dates column;

Finally select the duplicate column >sort by>Rank;

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@HenryJS ,

Create in your date table

Date 1 = Date

Date Rank = rankx(all(Date), Date[Date],,desc,dense)

Sort Date1 and on Date Rank and use Date 1 in your visual

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column