Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Found the solution.
Made two table visuals as you suggested and linked them on Client number.
Then the filter option is working
@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
Thats what i treid allready but doesn'tdo the trick for me.
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
Found the solution.
Made two table visuals as you suggested and linked them on Client number.
Then the filter option is working
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |