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!

[gthill]

Needed to this today and found a solution. In the report.json file there is an array near the top named pods. In this array each drill-through page is a section. The name can be linked to the generated name for each page further down in the file. If you re-order this array as you want them to appear this sorts the drill-through order for you. If anyone finds this useful and needs further details let me know and I will post them. 

[VeraVB]

forgot to add printscreens 

desktop sort order drill through: sort as I want it

published sort order drill through : not as I want it 

[VeraVB]

I'm facing the same issue, set the order correct in desktop version by making duplicates in the correct order and removing the initial tabs, works fine, but then I publish and the order is all mixed up again. How is it that such a simple thing as ordering is not available? 

[SilvioM]

This seems to only work if you create your Drill Through pages in the correct order from the start.  The issue I am having is that multiple drill through pages were created and the creation order their, no longer makes any sense.  It would be nice to indicate the order is some sort of a menu...

[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.