Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

using an client number from a visual

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.

Anonymous
5 years ago
Found the solution.
Made two table visuals as you suggested and linked them on Client number.
Then the filter option is working

4 Replies

amitchandak
Super User
5 years ago
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
  Not applicable
  5 years ago
  Thats what i treid allready but doesn'tdo the trick for me.
  - Anonymous
    Not applicable
    5 years ago
    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