Forum Discussion
Solved
Slicer Filtering Another slicer
Hi, I did my research on forum but I couldnt find solution for my problem. I have a main Data table and 3 small tables with distinct values to filter the data table. 1. Region, 2. City, 3. Distri...
Combine them all into one table that has all 3 fields. If you do that and have a slicer for each field, when you pick CA the city silcer will be filtered to only show cities in CA.
Another option would be to have a measure that counts the rows in your main data table then use that as filter on each of the slicer. You would set that to 'is not blank' and when you picked CA in the region the cities would be filtered. In my example below I have a measure that just counts the rows of the sales table. When I apply that as a filter to the slicer you can see it takes out the dates that do not have any records.
Slicer Filter = COUNTROWS(Sales)
If using just 1 of the checks works for you I would do that, it will be faster for the model to count the rows of 1 table instead of 4.