Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
79 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |