Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
My PBIX has both visualizations and slicers. When I change one slicer, all other slicers and visuals are updated, but when I select a certain value in a visual (ex: selecting a single bar in a bar chart), all other visuals are updated but slicers are not. Is there a way for visuals to filter slicer selections?
No slicer filtering selected:
Slider slicer filtered both the bar chart and the dropdown slicer.
Selecting the middle bar in the Values bar chart did not make a difference to either slicers. We want to be able to have the slicers dynamically change their values based on selected bar chart value.
Hi @ibrahimr ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.
Best Regards,
Stephen Tao
Hi @ibrahimr ,
Based on my test, the slicer can not be filtered by the visual.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@ibrahimr , Not very clear. But interaction is the driver bases. When I click on the bar, where all it can pass the values(Bar is the driver) . Same way when you click on the filter, What all visual will filter.
@ibrahimr , Please check your interactions, I can see that bar do not interact with the duration
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
For independent slicer refer : https://www.youtube.com/watch?v=cyOquvfhzNM
I just double checked, they are all interacting. I selected a bar in the second visual and then a selection from the dropdown, and that made the first visual empty.
Ordinarily, if they are interacting and the other slicer returns "empty", it would be that your slicer doesn't meet the parameters of the values you provided (i.e. the value you have selected lies outside the parameter values supplied.
In this scenario, If your data is from 2 sources, then you would need to model your data appropriately. Such that when you select "7" your model knows that its 7 consistiting of users, a, b, c.
I hope this steers anyone reading this in the right direction -
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |