Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow user to control sort order for Drilltrhough

Vote (2) Share
Scott Burggraf's profile image

Scott Burggraf on 14 May 2019 22:16:46

If you have multiple Drillthroughs that go do different reports/tabs, in Power BI Desktop the order of the drillthrough options when you right click is the same order as the tabs. When you publish to Power BI Service the sort order of the Drillthrough options from a field is different.

Would like to be able to set the rrder in Power BI Service.

Comments (1)
Scott Burggraf's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:57:57

RE: Allow user to control sort order for Drilltrhough

Either need the ability to sort the reports that are all set up on the same column, or need the ability to only show a single drillthrough based off a specific value of the column. For example, I have Column1 that has 5 unique values. If the value is 1, I want the user to use Drillthrough1, otherwise, use Drillthough2 (both Drill through are based off the same data column). My problem now is Drillthrough 2 appears before Drillthrough 1, and I'd prefer to sort them in alphabetical order or custom order, based off my needs.