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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Drill through selections

Hi Experts

Not sure if this is a problem or a normal feature of drill through. I have four drill through pages on my report.
1. America's
2. EMEA
3. APAC
4. REST

When I go to the America page and I right click on the visual to drill through it give me the option to drill through to all of the above as opposed to just America's. Am I doing something wrong or is this a standard feature of BI.
1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

What does you data look like? How do you use "drill through"?

I test with a simple dataset.

1.

2.png

2. add "area" in a table visual on page1, "details" in a table visual on page2,

3.add "area" in the "Dill through" filter on the page2.

3.png

3. select "America's" and drill through to page2,

4.png

5.png

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

What does you data look like? How do you use "drill through"?

I test with a simple dataset.

1.

2.png

2. add "area" in a table visual on page1, "details" in a table visual on page2,

3.add "area" in the "Dill through" filter on the page2.

3.png

3. select "America's" and drill through to page2,

4.png

5.png

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

I Maggie firstly thanks. I did the same step Now trying doing that when you have three similar tables for each of the region's. See what the drill through option is. If you are on the America's page the drill through allows the use to see when right clicking on the table the ability to Sri through to APAC also. I'll post an image sortly

Hi @Anonymous 

Is your problem sloved?

It seems you need to to add proper column in the "Dill through" filter on the drill through target page.

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Apologies Meggie yes, excellent feedback, sorry for the delay.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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