Forum Discussion

Dellis81's avatar
Dellis81
Post Prodigy
4 years ago

reverse date hierachy

Hello!   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 revers...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

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.

How to upload PBI in Community

Dellis81's avatar
Dellis81
Post Prodigy
4 years ago

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.  

 

thank you!

Sample File:  https://drive.google.com/open?id=18K9LpI59NoWGwB9TZgFmUqvGzHAMOQX0&authuser=daryl.ellis01%40gmail.com&usp=drive_fs



Sample File:  https://drive.google.com/open?id=18K9LpI59NoWGwB9TZgFmUqvGzHAMOQX0&authuser=daryl.ellis01%40gmail.com&usp=drive_fs