Forum Discussion
Drillthrough without Multiple pages
Hi Team,
I want to create a single drill-through page for multiple measures and multiple pages.
Can we do this on a single drill-through page parry2k lbendlin Ahmedx Kedar_Pande.
Thanks for the reply from lbendlin and audreygerred, please allow me to provide another insight.
Hi saud968 ,
I am not sure how your source dataset is designed, here is my sample.Using two simple measures to create a field parameter table.
Create a Drill-through page and then use the field parameters to create the visual.
Add the field parameter as a visual level filter for each card on the main page.
This will cause the drill-through page for the measure in the card to show only the desired measure.
Below is the drill-through page obtained after performing a drillthrough on the measure in the card.
This way, a single page can be used to drill-through for multiple measures. Hopefully this will meet your needs.Please see the attached pbix for reference.
Best Regards,
Dengliang LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Thanks for the reply from lbendlin and audreygerred, please allow me to provide another insight.
Hi saud968 ,
I am not sure how your source dataset is designed, here is my sample.Using two simple measures to create a field parameter table.
Create a Drill-through page and then use the field parameters to create the visual.
Add the field parameter as a visual level filter for each card on the main page.
This will cause the drill-through page for the measure in the card to show only the desired measure.
Below is the drill-through page obtained after performing a drillthrough on the measure in the card.
This way, a single page can be used to drill-through for multiple measures. Hopefully this will meet your needs.Please see the attached pbix for reference.
Best Regards,
Dengliang LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi! Any visual on any page that has a field/measure in it that is part of your 'drill-though from' will allow you to drill-through to that page.
Yes, I know that. May be I did not explain it properly.. I have 3 drill-through pages, I want the drill-through one only as shown in the screenshot above... Can I create drill through on onepage
I was thinking something like this article - https://community.fabric.microsoft.com/t5/Community-Blog/Single-Tooltip-page-for-different-measures-amp-different-visuals/ba-p/4202869
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
