Matrix with date in colum header - set to descending?

[JamesBowdidge]

Hi,

matrix date in col header is driven by calculated calendar and works perfectly. Except the oldest date is on the far left and user has to scroll all the way to the right to see latest data.  All we want to do is set the date the other way around.. and prevent all this unnecessary scrolling.. 

We have tried multiple fixes that have been suggested but nothing we do works, like this one adding the index col  https://community.powerbi.com/t5/Desktop/Sort-Date-Column-in-Matrix/m-p/602217

It doesnt matter how the calendar is sorted in the data veiw, the matrix headers will not change.. 

Feels like a really stupid problem to have, any help appreciated

thanks

J

[v-jianboli-msft · Accepted solution]

Hi @JamesBowdidge ,

Based on your description, I have created a simple sample:

Please try:

First create a calendar table like this:

Calendar = 
var _a = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))
var _b = MAX('Table'[Date])
return ADDCOLUMNS(_a,"ORDER",DATEDIFF([Date],_b,DAY))

Then sort by column:

Manage relationship:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.