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.
I've got a two page report, an overview page and a details page.
The data is proprietary so let me use an example with a similar data model. Let's say I'm modeling items in a grocery chain. I've got columns for "store," "aisle," and "type."
My overview page has a stacked bar chart showing a count of each "type" of item for each "store." (So: "store" is on the y axis, "count" is on the x axis, and the stacked bars breakdown the count by "type.") I also have a slicer that lets users select which type of products they would like to see.
On the details page, I have a similar stacked bar chart, except instead of having "store" on the y axis, I have "aisle." You can see what I'm going for by now, I think. The overview shows the breakdown of item types by store, and then you drillthrough on a store to see the same sort of breakdown by ailse.
Here's the rub, though: when I drill through from the overview page, it's over specific. The section of the bar I select will affect the values seen on the details page, which I don't want. In other words, it's drilling through on both "store" and "type" and I only want it to drill through on "store" even though having "type" in the details page chart is also important. I have thought about creating a duplicate column - "type2" - but I also use that "type" slicer on the details page and it's synced with the overview page.
After the fact, I can manually delete the "type" filter in the right pane under drillthrough, both in desktop and on the web report, so there must be a way to trigger that programmatically. How can I do that?
Hi @Zelbinian,
Slicer will effect the visual(including overview page and specific page), it filters the rows of table used to create the report. For your requirement, it seems unsupported now if my understanding is right, you can create an idea here.
Thanks,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |