Forum Discussion
Post ProdigyMultiple drill through measures
Hi lherbert501 ,
Thank you for the response..!!
It is possible to drillthrough.
Please find the attached .pbix for your reference.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
Community SupportHi lherbert501 ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you PijushRoy superuser for the prompt response.
- Yes, you can create a single drillthrough page to handle all 18 measures. This page will serve as the destination for the drillthrough action.
- On the drillthrough page, you will need to drag all 18 fields (measures) into the drillthrough filters section. This will enable the drillthrough functionality for each of these measures.
- Ensure that the drillthrough page is properly configured to display the relevant data when a user drills through from the matrix. This might involve setting up visuals and filters that respond to the context provided by the drillthrough action.
Please find the below Microsoft Documentation for your reference:
Set up drillthrough in Power BI reports - Power BI | Microsoft Learn
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Rama U.
Post ProdigyHi v-venuppu
If on my destination page I have just generic info that applies to all 18 measures, and the measure doesn't need to exist on the destination tablix, is there a way to do this?
In my testing the drillthrough works fine when a measure exists in the tablix, but I didn't know if it was possible to just drill through and at page level.
E.G If i had a phonecall count sales measure and a social media count sales measure and this was going through to a generic sales tablix, can this just show the sales on the tablix that exist in the context of a social media sale? E.G 8 social media sales so the tablix has 8 rows with generic sales info?
Thanks
Liam
- v-venuppu
Hi lherbert501 ,
Yes, what you are describing can be achieved, and it's a common pattern when you want to use contextual drillthrough without showing the measure itself on the destination page.
Here's some steps to achieve it:
- You do not need to place the actual measure in the destination tablix for the drillthrough to work. Instead, what matters is the context passed through the drillthrough filter.
- The key is to use categorical fields (dimensions) or filter-friendly fields that are associated with those measures (e.g., Channel, Sale Type, etc.).
- The context (via dimensions like SalesChannel) enables the page-level filters and makes the visual respond correctly.
- This allows you to create a generic destination page that dynamically adapts based on the selected measure’s context.
Here's an example for your reference:
- If you have a SalesChannel field with values like "Phone Call" or "Social Media", and your matrix uses that to split measures, you can drag SalesChannel into the drillthrough filter pane on the destination page.
- When users drill from "Social Media Sales", the page filters to just "Social Media" sales, and the tablix shows all 8 relevant rows.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you. - lherbert501
Hi v-venuppu
I can't seem to get it to work based on your instruction.
Could you please have a look at below and show me? It still wont allow drillthrough for all 4 measures I have
Thanks
- v-venuppu
Hi lherbert501 ,
I order to drill-through a particular field, you need to give that particular field in drill-through filter.
In this case , Sale type.
No need to give all 18 measures in drill-through filter.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.