Right click figures in matrix for line item drill-through from multiple data sources

[sabilahmed]

Hi,

I have a matrix viz below:

I want to be able to right click the figures and drill through to open a table showing all the line items and individual rev prices and other details.

The issue I have is that this matric is made from multiple data sources/ tables. See below:

How can I make this drill through work? What's the best way to go about this?

Thanks,

Sabil

[v-easonf-msft]

Hi, @sabilahmed 

You need  create a destination target page that has the tables visuals that you want for the type of entity that you're going to provide drillthrough for.Then, on that drillthrough target page, in the Build visual section of the Visualizations pane, drag the field for which you want to enable drillthrough into the Drill through well.

For more details, please refer to this official documentation on how to set up drillthrough in your report .

Set up drillthrough in Power BI reports 

You can also consider adding  a custom tooltip page to display the table.

Create tooltips based on report pages 

Best Regards,
Community Support Team _ Eason

[sabilahmed]

Hello,

Thanks for your response. Sorry I shouldh have been more clear. I kow how to do a page drillthrough set up and custom tooltip.

My question is more about I have mutliple data sources and want to create a single table to do a page drillthrough. How can I do this when the ID types across the tables are different and some of the tables are about recurring revenue and some are not.

Thats the issue i'm facing.

[PijushRoy]

Hi @sabilahmed 

If all relationship is working fine, I hope there si no issue for Drillthrough page.
Drillthrough is the filter, filter will work as per relationship you build.

If any drillthrough is not working, that means there are any issue in your relationship and you need to correct it.

Please specify what is the exact issue you facing and what are the dependent relationship, so it is more clear to understand.


If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

[sabilahmed]

The issue is not with the relationship but rather each row in the matix is related to a different table in the model. Please refer to my model screenshot.

I use a measure to SUM all the revenue columns from the different tables in the use that measure as my values for the matrix.

Is there a way I can create a different page drilthrough for each separate row in the matrix view? I know I can create a single page drillthrough with one table. But how can I do this with 5 different tables from the source?