Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RoryT
Frequent Visitor

Drillthrough deselection on save and reopen

I have a report in Power BI Desktop that includes a few tables on the first page that allow the reader to drillthrough to other pages in the report. I designate the tables for drillthrough in the Data / Drill > Drillthrough. However, after saving and re-opening this option become deselected again. Is it possible to permanently designate tables for drillthrough?

2 REPLIES 2
v-jianhe-msft
Resolver II
Resolver II

Hi,

>>> Is it possible to permanently designate tables for drillthrough?

So do you want to achieve the effect that when you reopen the report, the drillthrough action is remaining as the last time you close the report? If so, you could use the drill through filter.

 

For example, I have a table on page 3, and I add a drillthrough filter “Region”, then I add a same filter “Region” on page 4.

1.jpg2.PNG

Then when I select the drillthrough action, e.g. Region B, It can navigate to page 4:

3.jpg

Next time when I open the report, it stills remains “Region B” on page4, which remains the status of “Drillthrough”.

 

BR,

Henry

Thank you for your response Henry, I've set up a report in the same way you describe, except for one difference. On your page 3 you can select the table, navigate to Visual tools in the ribbon, and select Data / Drill > Drillthrough. This makes it so that instead of right-clicking a region in the table then navigating to Drillthrough to bring up the drillthrough menu (on which you probably just have Page 4), you can instead left click to immediately bring up the drillthrough menu. This is convenient, especially if users don't need to Show Data, or Include or Exclude rows (which are the other options aside from drillthrough when you right click), and they also don't need to filter other visualisations by table row (which is the default left click action for tables)

 

However, if I set this up then save and reopen, the Data / Drill > Drillthrough option becomes deselected. I'd like this option to stay associated with the table permanently.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.