Forum Discussion
Slicer Filtering Another slicer
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)
What is that slicer filter formula -can you please explain
i am in same situvation i need to filter slicer with another slicer - Is it posible to do it without merging all table inot 1 table ?
Thanks .
Hi,
I solved my problem without merging tables. I just created measure using countrows formula as you can see in accepted solution comment. I think what that formula does is that it makes bi understand that there are blanks in columns you are trying to filter. Just create a measure using countrows formula and drop it in every slicers filter pane and choose is not blank option as showed above and it will do the job I hope.