Forum Discussion
One visual only partially affects another visual
Hi garricksullivan ,
For the original tables of the visuals above, you may change the Cross filter direction of relationships among these tables from Single to Both , which will take these tables treated as a single table.
You can learn more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.
Then when you display and make selections for some fields of one table in visuals, the other linked tables' fields will return corresponding result in visuals .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- garricksullivan6 years agoRegular Visitor
Thanks for your reply!
Unfortunately, this doesn't seem to help the issue that I'm experiencing.
It's interesting and a bit confounding that two of the cost centers in the treemap work one way, and the rest don't. I've been looking at my data and I can't seem to find any difference in the fields that would make one center work over another.
- kinseld5896 years agoNew Member
hi garricksullivan,
think i know the problem here (i hope), when you select your tree map hover over the charts you want to be changed and you will see the symbols as shown below. the 2nd from the right (highlight) tend to be the default, you need to select the icon to the right, i.e. filter.
this should do the trick
Dave
- garricksullivan6 years agoRegular Visitor
Hi kinseld,
The options that you posted don't appear when I select the treemap and then hover over the other graph. I tried clicking through the options that were there, but they didn't have any effects (the only options were the filter icon which only lists what filters are affecting the visual, and the expend icon which give you a full page view of the graph)