How to click a value in table visual to go to another table visual with desired data automatically?

[bergen288]

I have the following 1st page to show unusual payment data in a table visual.

In 2nd page, I have payment history data with Subscriber as slicer so that I can search for target subscriber manually.  Is it possible to click (or double click) the subscriber value (...1601) in 1st page to goto 2nd page with the required history results automatically for interested subscriber? What's the best way to do it?

Thanks.

[Anonymous · Accepted solution]

Hi @bergen288 ,

Luckily, there is a feature called drillthrough in Power BI Desktop.

With drillthrough in Power BI reports, you can create a destination target page in your report that focuses on a specific entity such as a supplier, customer, or manufacturer. When your report readers right-click a data point in other source report pages, they drill through to the target page to get details that are filtered to that context. You can set up drillthrough in your reports in Power BI Desktop or the Power BI service.

Please kindly refer to

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

In addition to drilling in reports, you can also drill through across reports, please refer to

Use cross-report drillthrough in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[bergen288]

It works, the only thing is that the slicer in 2nd page no longer valid.  Anyway, I will take it.

Thanks.