Forum Discussion
Can a visual select items in a slicer?
I have a 'Scatter Chart' visual with an x axis of 'Respondent ID'. I'm also using Microsoft's 'ChicletSlicer' visual (which is not really a slicer) to give easy access to the selection of 'Respondent IDs'. These two visuals cross-filter on this report page, all is well in that regard.
I also have the standard slicer with 'Respondent ID' "Synced" across the other pages of my report, although it's only visible on this page. Using this standard slicer I can select one or more 'Respondent ID' values and see only the desired results on all the other tabs/pages.
I would much prefer if selecting a specific 'Respondent ID', or group of them using 'Ctrl-Click' on the 'Scatter Chart' or 'ChickletSlicer' visuals would give me the same cross-page filtering ability.
Is there a way to accomplish this? Here is what this looks like, currently:
It turns out the functionality I needed is drillthrough.
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
This allows me to select 'Respondent ID' on one page and then easily jump to other pages, filtering on that selection.
3 Replies
v-cherch-msftMicrosoft Employee
Hi JamesLeach
Do you want to use a visual to filter a slicer?It seems impossible.Here is the workaround about apply a filter to a slicer. For your requirement,you may submit an idea here.
Regards,
Cherie
Filtering the slicer with the visualization is an option - I did see a reference to that, before and will review it in more depth.
A better solution, if it's even possible, would be for the visualization to filter other visualizations across different pages of my report. I know I can sync sliders across pages but it doesn't seem possible to edit interactions of visualizations across pages or sync them in any way.
It turns out the functionality I needed is drillthrough.
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
This allows me to select 'Respondent ID' on one page and then easily jump to other pages, filtering on that selection.