I am wanting to reverse the normal order of columns (Dates) within matrix visual. Traditionally I have used the date hierachy and really like those features. Now, I am wanting to reverse the order that the hierachy returns.
I have been able to create a "reverse" sort column within the calendar table, and then sort year by this 'reverse year column". I get the results I want when I only include the normal data field 'Year" within the matrix column well. However, when I select the Hierachy Year column - reverts back to the normal sort order.
IS there a way to create a date hierachy that allows for reversing dates (current date in left column, descending backwards in time
Hi, @Dellis81 ,
Did you download my file, try to get it right, or
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
Ok, I have been able to get the reverse sort by columns if I exclude a dimension in the "row" well. However - if I have a dimension in rows, then the matrix sort only allows sort by row.
Hi, @Dellis81 ,
First you drill down to the bottom of the date, and then display it in descending order. No matter which layer you go back to at the moment, it's the reverse.
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your response. Your example is using the matrix sort by 'rows' feature. I am looking for reverse sort within matrix columns.
@Dellis81 , Try if this can help. If not you have to create customer hierarchy with each column having a sort column
Date1 = [Date]
Sort Column = Rankx('Table', [Date],,desc,dense)
Mark sort column as column for date1 and use that
Or create year, month qtr etc
Year1 = [Year]
Year Sort = Rankx('Table', [Year],,desc,dense)
And create a hierarchy using such columns
Thank you for your response. I have attempted several times on your suggestion. I am able to creae a 'reverse date hierachy', but whenever I place this new hiearchy in in the column well - the order goes back to ascending.
If I was to put the Reverse Yr Column (not use hiearchy), then I get what I expect. I suspect the hiearchy feature does not allow for the customized sort. Do you know if that holds true in non date hiearchies?
Appreciate your help - sorry for slow response, I have tried off/on over the past few days - thinking I would eventually get it. Your solution seems logical.
Click here to learn more about the August 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.