Forum Discussion
Gantt Chart By MAQ Software Sort rows
Hi Anonymous ,
If you use the ordering function in MAQ Software,it will be applied in all the columns,the only solution is to create a measure to get the ordering number.You could use rankx or TopN function.
Check the references below:
https://docs.microsoft.com/en-us/dax/rankx-function-dax
https://docs.microsoft.com/en-us/dax/topn-function-dax
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
For our table, an easier solution was to sort and then add an index.
1. Get the table to a state you need it
2. Sort by Start Date
3. Add Index column (native Power BI)
Then in the Visual, I just added Index as the first Category, renamed it as ID, and done. Then I was able to have the milestone title as the second value in the Category and it looked just perfect. No special expressions needed during the Transform Data.