Order of Drillthrough target names

[MelStaunton]

Hi!

how is the order of the drillthrough targets determined? Mine is neither in alphabetical order nor in the order of the tabs of each report. Is this random or can I define the order somewhere?

Thank you!

[v-diye-msft]

Hi @MelStaunton 

I think the order is based on a sequence of pages get created. Seems like it has some internal sort order on page creation. And no relevant documents were found.

you'd better create a support ticket in Power BI Support to get further help.

[MelStaunton]

Your input is much appreciated, thank you!

I will create a ticket and update here if there's additional info.

[MelStaunton · Accepted solution]

Here's what MS had to say:

When you create a tab an ID# is auto-assigned in the background.

Drillthrough targets are sorted in ascending order by same ID#.

To sort them, one would have to chronologically duplicate the pages in the order they should show in the drillthrough target list and delete initial pages.

If new targets/tabs are added after the initial order is setup, they will show at the bottom of same list.

Hm. Not great but workable.

[Greg_Deckler]

Is it the order in which you created them?

[MelStaunton]

Possibly, I am not sure, I added and deleted a few options to show my users.

Seeing I have a few it seems insane having to recreate to show in an order that would make sense to users?

We will add more pages as we go and then the order is not in any logical order anymore either?

[Greg_Deckler]

Hmm, odd, I ran an experiment and mine came out in alphabetical order and that was not the same order in which I created them. That being said, they all had the same drill down column. So, might be more complex than just alphabetical order. I will see if I can do some more experiments.

[Greg_Deckler]

OK, I did some more experimenting. It's odd. It seems that when I created 3 pages and then enabled drillthrough for each, it placed them in the correct alphabetical order, not the create order. So then I created another 3 pages starting with "A" versus "P" as before. I then setup drillthrough on these. It placed these under the P pages but placed them in the correct alphabetical order for all of the A pages, which was not the creation order. 

So, from my experiments what it looks like is happening is that it places them in alphabetical order but some event, like a page creation can end up "resetting" this such that the next additions are in creation order. Very odd.