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 ...
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
Super User
Super Useryou provide a <orderBy_expression> so only can't guarantee sort order if there are ties