Drillthrough from Matrix Visual

[Vanshikaw5]

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

[Vanshikaw5]

Same field is not being used for one page outlets is the field and for the other page appliance.

[PijushRoy]

Which field you used in the Outlet page for Drillthrough

Which filed you used in Appliance page for Drillthrough

Share screenshot

[Vanshikaw5]

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.

[PijushRoy]

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.

[Vanshikaw5]

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.

[PijushRoy · Accepted 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

[PijushRoy]

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