Forum Discussion
Hierarchy sorting
I have a hierarchy above in my report and it goes down to level 9. I also have a reporting order ID tagged at level 1 and when I try to sort this, it shows the following error. Fro...
Hi tearless
Please add SortOrder column for each 9 columns in your database
or use Power Query conditional column to add a SortOrder Column.
This is what I did.
I created hierarchy tables Level1... to Level 9 with ID that shows the order of each hierarchy member.
Then I joined these 9 tables with the data table which has those hierarchy member.
Then, I selected each hierarchy table and sorted by those IDs..
But the report still does not get sorted as needed.
