on 14 Jun 2019 21:10:43
If a slicer option is selected that would cause the underlying table to filter to that value, update other slicers to show only values in the remaining set of data, post filter. I.E. slicer selection should filter the remaining slicer selection options.
- Comments (2)
RE: Filter Slicers based on other Slicer selection.
This is essential as it adds confusion to the user if the data disappears due to the filter not updating dependent filters with a new member from the dependent filter. It also can also add additional pages if you work around this with multiple pages to cater for the different dependent options. This decreases user understanding and increases developer maintenance and complexity.The sooner this is resolved the better for all.
RE: Filter Slicers based on other Slicer selection.
This functionality is a basic feature of Tableau. All you need to do is drag the field to the filter view and all filters in the pane filter each other. Why is this so hard to accomplish in PowerBI?
Here is the long workaround for this:
https://www.fourmoo.com/2017/01/24/power-bi-how-to-filter-slicers-dynamically/