How to get target data in table after double click target X in line chart

[bergen288]

I have the following 2 pages in my report.  The 1st page has 2 line charts for Payments by hour  but my focus is on 2nd line chart.  The 2nd page is a table to list data plus an hour slicer on left.  My question is, how may I select target data at 11 in page 2 as shown in 2nd screenshot after double click at 11am in 2nd line chart at page 1?   It must be some kind of drill-through or drill-down.

Thanks.

[Anonymous]

Hi  @bergen288 ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Value_Measure =
SUMX(ALLSELECTED('Table'),'Table'[Value])

2. Result:

Click the value of Visual, click which point to display the corresponding data back, will not be affected by the hierarchy:

Best Regards,

Liu Yang

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

[bergen288]

Yang:

My question may not be explained very clearly in my post.  Sorry to confuse you.  I added additional data in your example to have multiple Values for each Index.  Here is the link to download MyExample.pbix file: https://github.com/bergen288/public/blob/main/MyExample.pbix.  There are 2 pages: the 1st page has a line chart whose X is Index and Y is Value.  The 2nd page is the combination of Index slicer and table with detail information.  At line chart, we can see the Value peak is at Index 3 so we would like to see details at Index 3 or any other details.  My question is if it is possible to double click line chart at Index 3 to bring up 2nd page with detail information at Index 3 automatically.  If there is no way to jump from page 1 to page 2 by double click it, at least I would like to have page 2 to display data with correct filter so that if I double click at Index 3, the Index slicer at page 2 is checked at 3.  With such small detail table in example, it might be better to use tooltips.  However, my detail table is much larger to have a new page.