Forum Discussion

Resolver II

2 years ago

Solved

How to filter a table based on 3 slicers?

Hi guys, I have a case where customer wants to show a table with specific dates based on slicer. For eaxmple I have so many dates and the table should show only three dates as below: How ...

MFelix
2 years ago
Hi AsNa_92 ,

I'm talking about having 3 additional tables on your model that will allow to force the filtering that you need.

The measure is the following:

Filter values = COUNTROWS( FILTER('Table', 'Table'[Date] in VALUES(FilterDate1[Date]) || 'Table'[Date] in VALUES(FilterDate2[Date]) || 'Table'[Date] in VALUES(FilterDate3[Date]) ) )

Add your measure has filter of your visualization making the filter is not blank

Please see file attach. Don't mind the data and the formats because is just an example.
3FilterVisuals.pbix23 KB

MFelix

Super User

2 years ago

Hi AsNa_92 ,

I'm talking about having 3 additional tables on your model that will allow to force the filtering that you need.

The measure is the following:

Filter values = 
    COUNTROWS(
         FILTER('Table',
           'Table'[Date] in VALUES(FilterDate1[Date]) ||
           'Table'[Date] in VALUES(FilterDate2[Date]) ||
           'Table'[Date] in VALUES(FilterDate3[Date]) 
                )
              )

Add your measure has filter of your visualization making the filter is not blank

Please see file attach. Don't mind the data and the formats because is just an example.

3FilterVisuals.pbix23 KB