Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have a user requirement where I need to drill through from 2 different columns on 2 different pages on a matrix visual. I am able to acheive this via drill through functionality. The only catch is that the inner row header is showing drill through for both the pages and I need each column to send to its own page. Eg. when the user clicks on one of the cities it should give the user the ability to just the outlet page.
Any help would be highly appreciated.😊
Regards
Vanshika
Solved! Go to Solution.
Hi @Vanshikaw5
Please find the report link
https://drive.google.com/file/d/1n3kBkMorI-pOmlPrPGPB0hcD9HHRnbjk/view?usp=sharing
If solved your requirement, please mark this answer as SOLUTION
Thanks
Pijush
Same field is not being used for one page outlets is the field and for the other page appliance.
Which field you used in the Outlet page for Drillthrough
Which filed you used in Appliance page for Drillthrough
Share screenshot
Hi @PijushRoy ,
Thanks for your response. As shown in the earlier screenshot we have two different fields used for row headers. Those 2 fields are used as drillthrough fields in their respective drillthrough pages.
Please let me know if you still need the screenshot.
Hi @Vanshikaw5
I am not clear, better you can create similar pbix file and share to get answer quickly.
Not include any sensitive data.
Upload the file in Google drive, give access for all and share the link.
Hi @PijushRoy ,
PFB the link to the report:
https://drive.google.com/file/d/1im8n-PQ-ev1ZZwIz9WJeIdJ2wXIg5z2a/view
In the report as you can see a user will get 2 drill through pages from the inner field i.e. outlet. I need that the user only gets the option to drill through to outlet page, not appliance.
Please let me know if you know of any workaround.
Hi @Vanshikaw5
Please find the report link
https://drive.google.com/file/d/1n3kBkMorI-pOmlPrPGPB0hcD9HHRnbjk/view?usp=sharing
If solved your requirement, please mark this answer as SOLUTION
Thanks
Pijush
Hi @Vanshikaw5
As you are using the same field for 2 Drill Through 2 pages, 2 pages will pop up for Drill Through.
If you want, you can break data into two tables or use two tables that overlap each other.
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS