Drill through functionality

[yoki]

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

[yoki]

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

[Ritaf1983]

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

[yoki]

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)

[Ritaf1983 · 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

[Ritaf1983]

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