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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
yoki
Regular Visitor

Drill through functionality

pie and donut chart in main report and respective table for each chart on drill through page(single page) when i drill through from pie chart it needs to only show pie chart table and vice versa. Both chart have continent as drill through field and these charts differ from 4 fields pie chart have continent,tot cases//1m pop,tot death/1m pop and donut chart have continent,total  cases,total deaths

1 ACCEPTED SOLUTION

Hi @yoki 
The drillthrough functionality operates at the page level, applying the filters from the visualization where the drillthrough is performed. In other words, the action doesn't include "focusing" on a specific object or hiding objects. If you're interested in seeing different visualizations when performing drillthroughs from different graphs, you need to create separate drillthrough pages for them.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

5 REPLIES 5
yoki
Regular Visitor

I shared this report file via one drive if you can able to help please reply.Thanks Example Report

Hi @yoki 
It seems that the drill-through works as expected, filtering the detailed table by region. What seems to be the issue?

Ritaf1983_0-1728112354126.pngRitaf1983_1-1728112401372.png

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Drill through works there is no problem But what i wanna achieve here is ,you can see there are two charts on the main page: a pie chart and a donut chart. On the drill-through page, there are two tables: the first table represents the pie chart, and the second table represents the donut chart. I would like to achieve the following: when I drill through from the pie chart on the main page, I only want to see the first table (representing the pie chart) and not the second table. Similarly, when I drill through from the donut chart, I only want to see the second table (representing the donut chart)

Hi @yoki 
The drillthrough functionality operates at the page level, applying the filters from the visualization where the drillthrough is performed. In other words, the action doesn't include "focusing" on a specific object or hiding objects. If you're interested in seeing different visualizations when performing drillthroughs from different graphs, you need to create separate drillthrough pages for them.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Ritaf1983
Super User
Super User

Hi @yoki 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.