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.
I have several visuals on 1 page. They are related to two different datasets which both have "owner" column. When I ,click on my bar graph with the name, I want the the tile summary in the other visual to change based on the owner selected in the bar graph. Is there a way to dynamically apply a filter to a visual based on a value from another visual?
Thanks,
Justin
Hi @jwhitf4770,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your data sample and the relationship you created, so that we can help further investigate on it?
Best Regards,
Cherry
I have the bridge table built. How do I apply it to AIM Request Completed? Unfortunately I didn't design the data.
Its all about Filter Context. There are several appraoches. The simplest but most limited is to change teh Filter Direction on one or both of the relationships to Both. You can also wrap your measure in a calcualte and specify CROSSFILTER as the filter or just put the other table name.
Here is a tutorial I put together to help expalin filter context a little more.
Thanks I'm working through the examples. The tough part is that "owner" is not unique in either table.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |