Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi I have four visuals setup as follows;
If I click on the map or "Global Breakdown" Chart the "E-Learning" & "Who Works in this Region / Country" charts adjust as expected.
The problem I have is I then want to be able to select different name listed within the "Who works in this Region / Country" chart one after another to adjust the e-learning chart to see teh status on a person by person level, this works but the names in listed within the "Who Works in this Region / Country" Chart resets back to show everyone in the world so I have to press the country again to get back to the filtered chart. Is there a way I can stop this?
Hope that makes sense, apoloigies if this is simple but I'm new to Power Bi.
Many thanks.
Solved! Go to Solution.
HI @gwoodley
When you select one data component ( ex: country in your case), all other visuals will be filtered based on the cross filter direction in your datamodel (and Edit interaction setup in the page). When you selct the another data component, Power BI releases the existing filter and will start filtering based on the latest selection ( in your case who works?).
You need to press control key to include second data component in the selection. ( Click the "India" first + press control key + select the who works? component).
Thanks
Raj
HI @gwoodley
When you select one data component ( ex: country in your case), all other visuals will be filtered based on the cross filter direction in your datamodel (and Edit interaction setup in the page). When you selct the another data component, Power BI releases the existing filter and will start filtering based on the latest selection ( in your case who works?).
You need to press control key to include second data component in the selection. ( Click the "India" first + press control key + select the who works? component).
Thanks
Raj
Thanks Raj,
That really was easy🤔