Date sorting

[Anonymous]

I have the below visualzation set up on my BI. Because I am calculating MoM% Chg and YOY% Chg in BI, I have to show the data using the date hierarcy. Problem is, when I sort by date, it has the latest on top and newest on bottom. Does anyone know how to sort it with newest on top? I have it sorted right now by year, but if I switch the order ont he year, the months aren't in order any more. 

[Anonymous · Accepted solution]

You can "double-sort" on a table visualization by Shift + clicking on each column. 

https://www.c-sharpcorner.com/article/how-to-sort-a-table-using-multiple-columns-in-power-bi/