using an client number from a visual

[Anonymous]

Hi,

I.ve got an report with an visual of multiple provisions for an client.

These provisions are specific chosen.

Now i want to have another visual view with the clients form the first visual , but than with all other provisions the client has had at any time.

To show the example i've made an visual where i specific filterd on the client number.

So the first visual is clients who have got a provision 47a00.

In the second visual i've picked clientnumber 19397 for all other provisions.

[amitchandak]

@Anonymous , First will pass client name and other common parameters. So if you do not want to pass the code, then do not take from the common table.  Take from the fact.

Or have code parameter and disable its interaction with 2nd visual : https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[Anonymous]

Thats what i treid allready but doesn'tdo the trick for me.

[Anonymous]

HI @Anonymous,

I'd like to suggest you create two report pages with table visuals, then you can setting up the drill through filter on the key field which you mentioned:

Set up drill through in Power BI reports 
Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Found the solution.

Made two table visuals as you suggested and linked them on Client number.

Then the filter option is working