Forum Discussion
Visual not interacting with all slicers
It's possible that the visual that is not interacting with all slicers may have different filter settings compared to the visual that is working correctly. Here are some things you can check to troubleshoot the issue:
Check the filter settings for both visuals: Make sure that both visuals are using the same filters and are set up to interact with the same slicers. You can do this by selecting the visual and going to the Visualizations pane, then checking the Filters and Interactions sections.
Check the order of the visuals: Make sure that the visual that is not interacting with all slicers is not placed on top of the other visual. If it is, try moving it to a different position on the page.
Check the filter context: When multiple visuals are on the same page, they can have different filter contexts which can affect how they interact with slicers. You can check the filter context by selecting the visual and going to the Fields pane, then checking the filters that are currently applied.
Check for conflicting slicers: Make sure that the slicers being used by both visuals are not conflicting with each other. For example, if one slicer is set up to filter by year and the other slicer is set up to filter by month, this could cause issues with the visual.
Check for conflicting visuals: If both visuals are using the same dataset, make sure that they are not conflicting with each other. For example, if one visual is using a table visualization and the other is using a chart visualization, this could cause issues with the visual interactions.
By checking these things, you should be able to troubleshoot and resolve the issue with the visual not interacting with all slicers.
It's possible that the visual that is not interacting with all slicers may have different filter settings compared to the visual that is working correctly. Here are some things you can check to troubleshoot the issue:
Check the filter settings for both visuals: Make sure that both visuals are using the same filters and are set up to interact with the same slicers. You can do this by selecting the visual and going to the Visualizations pane, then checking the Filters and Interactions sections.
Check the order of the visuals: Make sure that the visual that is not interacting with all slicers is not placed on top of the other visual. If it is, try moving it to a different position on the page.
Check the filter context: When multiple visuals are on the same page, they can have different filter contexts which can affect how they interact with slicers. You can check the filter context by selecting the visual and going to the Fields pane, then checking the filters that are currently applied.
Check for conflicting slicers: Make sure that the slicers being used by both visuals are not conflicting with each other. For example, if one slicer is set up to filter by year and the other slicer is set up to filter by month, this could cause issues with the visual.
Check for conflicting visuals: If both visuals are using the same dataset, make sure that they are not conflicting with each other. For example, if one visual is using a table visualization and the other is using a chart visualization, this could cause issues with the visual interactions.
By checking these things, you should be able to troubleshoot and resolve the issue with the visual not interacting with all slicers.
Thank you for each of these suggestions! Will bear this in mind for future reports however I was able to resolve this by modelling the data slightly differently in excel and starting a fresh.
