Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape 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.
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
Solved! Go to 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
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?
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
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
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
User | Count |
---|---|
94 | |
92 | |
84 | |
83 | |
49 |
User | Count |
---|---|
145 | |
142 | |
111 | |
71 | |
55 |