Forum Discussion
jmg80525
Helper II
Helper IIDAX statement that groups and creates index dynamically
Greetings: I have a report where I utilized the Microsoft Gannt visual. In typical Gannt fashion it will put the Gannt element with the oldest date on top and then sort accordingly on date; top ...
Deku
Super User
Super UserYou can use SUBSTITUTEWITHINDEX to perform a multi column ranking. Add the measure to the table and sort the table by it. Then reduce the columns width until it is not visible
See this video by SQLBI
jmg80525Helper II
Helper IIHere's a link to a sample PBIX. A precursory glance at SubstitueWithIndex documentation suggests that
This function does not guarantee any result sort order.
. To replicate the issue choose June on the calendar slicer. Note the reordering of the regions in the Gannt chart. You will see that I have ordered sorting on the RegionSort column and ProjectName uses StartDate
- Deku
you provide a <orderBy_expression> so only can't guarantee sort order if there are ties