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)
Hi, if I have four main tables which have different slicer tables connected. Then do I need to add that Slicer Filter measure in all 4 main tables and then add them to Filter for all slicers?
Thanks in advance.
You could make a single measure that checks all 4 detail tables at once and use that filter measure on all the slicers.
Filter Measure =
VAR _Claim = COUNTROWS ( vCLAIM )
VAR _Invoice = COUNTROWS ( vINVOICEDETAIL )
VAR _Dist = COUNTROWS ( vINVOICEDISTRIBUTION )
VAR _Agg = COUNTROWS ( vREINSAGGDETAIL )
VAR _Check = _Claim * _Invoice * _Dist * _Agg
RETURN
IF ( _Check = 0, BLANK(), 1 )If any of the counts return 0 the _Check will be 0 and give the blank and you can set the filter to 'Is Not Blank'
Even adding one of those variables to the slicer filter works for me. Is it okay, or is it better to make product of those 4 variables and then add it to the slicer filter?