Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I hope someone can help
I have a matrix table which shows key points through my project with information whether those points are complete etc...
I would like to sort the columns by a date column (Task finish date) but I get the error "We cant sort the 'taskName' column by 'TaskFinishDate'. There can't be more than one value in 'TaskFinishDate' fr the same value in 'TaskName'".
I did have a work around where I used a calculation to create a sort column based on the name of the task. However this only works if the key points are consistant for all projects which unfortunately they are not.
Is there another way to sort by a date column?
Example table below
Task Name | Task Name | Task Name | Task Name | Task Name | Task Name | |
Task Finish Date | 01-Oct-18 | 20-Jan-17 | 19-May-18 | 15-Jun-19 | 18-Mar-20 | 16-May-18 |
Info 1 | ||||||
Info 2 |
Thanks
Matt
Solved! Go to Solution.
Hi
Turns out, the matrix table has an option to sort the columns by one of the values. sorting by finish date solved my problem straight away without the need for a complex DAX formula
For anyone else who has had this issue, if you click on the 3 dots at the top right of the visual it opens a list and one of the options lets you sort by
Thanks
Matt
the problem is that one date can have multiple tasks, in DAX for the custom sort to work the granularity of the involved columns has to be 1:1
would putting the date before the tasks list in columns solve the problem?
Hi
I have managed to sort by using a unique task ID column and sorting that by finish date. This solves one problem, however, I now need to have this number in the matrix table title for the ordering to work.
Is there a way to hide this top tier of titles without it affecting the order of the table?
Thanks
Matt
Hi
Turns out, the matrix table has an option to sort the columns by one of the values. sorting by finish date solved my problem straight away without the need for a complex DAX formula
For anyone else who has had this issue, if you click on the 3 dots at the top right of the visual it opens a list and one of the options lets you sort by
Thanks
Matt
Hi @Matt22365,
I'd like to suggest you create multiple sort order tables with custom index and link original columns with relationships.
Then you can use these related table columns to replace original columns to apply their own sort order instead original sort order.
Reference link:
Regards,
Xiaoxin Sheng
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |