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
JamesBurke
Helper III
Helper III

Drill down buttons

Hi all , 

 

I have a Main Page in which consits of a basic tree Diagram which is at a building level , this has a drill down button leading to the first drill down page, looking at daily performance etc for an indivdual building. 

 

I then want to use this first drill down page to drill down even further into a second drill down page looking at breaking the building down into floors etc. 

 

I'm wondering if there is a way for me to be table to keep drill down point of data from the first drill down and use it on the second without having the user selecting another point of data

 

For example if on the main page i drill down onto store 1 i then would like the user to be able to use the drill down button to drill down into store one without having to click again ( other then clicking the button ) . 

 

I created a work around using : 

Detail If Thornton Selected = 
 VAR SelectedGroup = SELECTEDVALUE('Emporia Devices'[Wawrick Device Name (groups)])
 RETURN
 IF(SelectedGroup = "Thornton Building","Page 1",BLANK())

 

Which is a button and when thorton ( store 1 ) is selected i can use the button however the filters are not carried across onto the next page like a drill down page would. 

 

Help please 🙂

1 REPLY 1
v-jialongy-msft
Community Support
Community Support

Hi @JamesBurke 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

 

 

 

 

 

 

 

 

 

 

Best Regards,

Jayleny

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.