Table nagavtion two tables

[Saxon10]

Hello,
I have two tables are US and UK.
I build the column chart on visualization based on the both tables in page 1 and 2nd page summary of the chart and table data for US and UK.

I like to kepet everything in one page and I don't want to build multiple page for summary and table of UK and US. 

I am trying to assgin the page nagavtion in-between page 1 and page 2.

The page nagavtion will show the summary and table depends on the selection of the chart.

Example - If I select the US chart from page 1 then it will show only US summary and US Sale table only in page2 insted of showing all the summary and table and the same thing for Uk.

[PaulDBrown · Accepted solution]

Here is one way. Firstly, instead of having seperate tables for each country, create a single table by appending the tables in Power Query:

I've also created dimension tables for Year, Country and Product (which is recommended).  The model looks like this:

For the values, I've created a simple SUM measure for the sales.

Set up your charts including the country field in the x-axis as follows.

Drill down to the lowest level and turn off concatenate labels in the x axis in the formatting pane.

Next create the details page with the visual including fields for Sales code, Year, Product and the Sum Sales measure.  At the bottom of the add data view, drag the country field into the Drillthrough option and turn off "Keep all filters".

You will see that an icon appears on the page wich is set to go back to the previous page by default, which is what you need.

 Now you can navigate to this details page to see the data by country by simply right clicking on any bar of a chart, selecting Drilltrhough and going to the detail page:

 The arrow button will take you back to the original page (in Desktop you need to ctrl + click; once published it will work just by clicking it)

If you want to make the drillthrough more inutitive (though it will disable cross-filtering, you can activate the "Drillthrough" icon. This enables the Drilltrhough options by simply clicking on a bar (instead of having to right click)

I've attached the sample PBIX

[Saxon10]

Thanks for your response and solution. Sorry for the late response.