Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
using “Gantt Chart” By MAQ Software component in a report I have the need to order lines presented based on the "start date" of the activity which form me is the second column.
It seems it should be possible since small arrow are present in each column header.
By default the order applied is the alfabetic one on the first column (task name in this case) and clicking on the arrow it change the order (ascending / descending).
It seems it is also possible to order by other column: arrows are present also there.
Problem is that order is "additional", menaning that rows are ordered by first column, THEN by second column. It seems it is not possible to order only by second column.
In adiditon I noticed that before ordering with second column the first one must be ordered ascending. If it is descending, at first click (on the second column arrow) the order of the first column is changed to ascending and at the scond click (always on the second column arrow) the order in the second column is also changed.
Could you help me in finding a way to order ONLY by a single column on not with the combination af all (starting from the left)?
Thanks
Enrico
Solved! Go to Solution.
Hi @enrico-ferrari ,
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,
Kelly
Did I answer your question? Mark my post as a solution!
Hello,
We’ve notified our engineering team of “Sort by column” request. We value end-user experience and regularly add features based on feedback. Please follow our beta build page for new feature announcements.
If you have an urgent need for a custom feature, please contact sales@MAQSoftware.com
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.
Hi @enrico-ferrari ,
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,
Kelly
Did I answer your question? Mark my post as a solution!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |