Forum Discussion
Report Design Suggestions
Hello powerbieng
You can't hide an entire slicer based on the selection in another slicer but, what you can do, is filter the list that appears in the slicer based on the selection in another slicer.
For example, if we have a master measure, something like Sales = SUM ( Orders[Amount] ) or whatever top tier calculation you want to use you apply a filter to all the slicers.
In the image below both the Year and Qtr-YR slicers have the filter [Sales Amount] is not blank applied. When I select a value in one, the other is filtered to only the matching portion of the list.
Hello powerbieng
You can't hide an entire slicer based on the selection in another slicer but, what you can do, is filter the list that appears in the slicer based on the selection in another slicer.
For example, if we have a master measure, something like Sales = SUM ( Orders[Amount] ) or whatever top tier calculation you want to use you apply a filter to all the slicers.
In the image below both the Year and Qtr-YR slicers have the filter [Sales Amount] is not blank applied. When I select a value in one, the other is filtered to only the matching portion of the list.