How do I use information from one visual in another visual?

[nadjablomkvist]

Hi,

I´ve built a visual (table) at one page in Power BI Desktop based on a live connection from our database. With using filters this results in a list of customers in one column, "Customer number", in this case. Now, I would like to use those Customer numbers to create a new visual based on those specific customers, on another page. Same database, so no other source is involved. 

Thanks so much in advance! Just ask if something isn´t clear in my despription

[v-frfei-msft]

Hi @nadjablomkvist ,

As @amitchandak  said, dirll through should meet your requirenmt in your scenario. One sample for your reference.

[nadjablomkvist]

Thanks for your input @v-frfei-msft  and @v-frfei-msft 

 It doesn´t seem to work in my case though:

On page 1 I have a list of companies & quantity. These companies are filtered, based on a specifik contract id, lets say contract 1 and contract 2. So on this page, I only see customers and their quantity that are linked to contract 1 and contract 2.

However, these companies also have quantity that are not connected to contract 1 and contract 2, so on page two, I would like to see all companies from page one, but their total quantity, not just the quantities related to contract 1 and contract 2.

[v-frfei-msft · Accepted solution]

Hi @nadjablomkvist ,

Report page tooltips should help. Please refer to the online document as below:

https://docs.microsoft.com/en-us/power-bi/desktop-custom-tooltips

BTW, I have created a sample for your reference.

[amitchandak]

Have you tried drill through

https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough