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.
Is there a way to carry over cross highlighted in a page to another page via drill through?
I know we can carry over Slicers but is there a way to capture the cross-highlighted
into a drill through page.
Here is the scenario:
One chart shows sales amount by sales rep and another chart shows sales amount by customer.
If we select a salesrep in the sales rep chart, the customer chart highlights/filters the chart for that sales rep.
I have setup a drill through from the customer chart to another page that shows more details on the customer.
It would be nice if the drill through captures the selected sales rep in the drill through page without needing to add a sales rep slicer.
Thanks!
Solved! Go to Solution.
Hi acbg,
Yes, besides passing all filters to the drillthrough window, you can also add a measure or a summarized numeric column to the drillthrough area. Drag the drillthrough field to the drillthrough card to apply it.
Reference: https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough.
Regards,
Jimmy Tao
Hi acbg,
Yes, besides passing all filters to the drillthrough window, you can also add a measure or a summarized numeric column to the drillthrough area. Drag the drillthrough field to the drillthrough card to apply it.
Reference: https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough.
Regards,
Jimmy Tao
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.