Forum Discussion
Sort not working
Hi ArchStanton
You could create a manual table where you maintain the items in a distinct list with an additional column where you define the order of the items. I call it the sorting ID.
You can bring in the data of the new table by connecting it to your data kodel or by applying a join/merge on the real table with the Age Profile.
Afterwards you should have besides to the Age Prodil also your sort ID in one table. Then you can use the sort by column feature where you sort one column by the order of another one. Please find below an example for a date table where I sort the month name by the month number:
the natural sorting of my monthname but be wrong. But thanks to the sort by column feature when I use the Month Name in a report it sorts it correctly.
So to make a long story short please make sure that you have next to your AgeProfile Column another numeric column which gives the order of this column. Then use the sort by column feature and you should be good to go.
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
Hi ArchStanton
You could create a manual table where you maintain the items in a distinct list with an additional column where you define the order of the items. I call it the sorting ID.
You can bring in the data of the new table by connecting it to your data kodel or by applying a join/merge on the real table with the Age Profile.
Afterwards you should have besides to the Age Prodil also your sort ID in one table. Then you can use the sort by column feature where you sort one column by the order of another one. Please find below an example for a date table where I sort the month name by the month number:
the natural sorting of my monthname but be wrong. But thanks to the sort by column feature when I use the Month Name in a report it sorts it correctly.
So to make a long story short please make sure that you have next to your AgeProfile Column another numeric column which gives the order of this column. Then use the sort by column feature and you should be good to go.
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
Thanks for this.
My DAX knowledge is still limited but I managed to use parts of your advice to fix the problem.
I created a simple excel table with 1-9 Rank and the corresponding date bands (0-3, 3-6 etc)
I added this to the model and joined the tables on the rank column, which I then used to sort the date bands in the table. I swapped these date bands for the old ones and it fixed the problem!
I'm sure there's a quicker way to do this but I don't care! Thank you for helping me, I was well and truly stuck until you intervened 👍
Hi ArchStanton
Thakn you for your feedback. Can you please mark it as solution to make it better finable for others? I appreciate your thumbs up.
Best regards
Michael