Forum Discussion

AsNa_92's avatar
AsNa_92
Icon for Resolver II rankResolver 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 can I apply that in PowerBI Desktop?

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    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.

     

     

     

     

6 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    2 years ago

    Hi AsNa_92 


    For this you need to have 3 different disconnect tables to make your slicer selection and then add a measure that will allow you to filter the results should be something similar to:

     

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

     

    • AsNa_92's avatar
      AsNa_92
      Icon for Resolver II rankResolver II
      2 years ago

      Hi MFelix 

      But if I created separate tables then I don;t need to create measue. 

      I can easily edit interaction and select none.

       

      Is there a way to make it in one table? 

      like with condition of where date equal to slicer1, slicer2 and slicer3 ?

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        2 years ago

        Hi AsNa_92 ,

         

        The tables need to be created in a disconnected manner, meaning that they don't have any relationship with your main table, then you need to create the measure to get the correct filter context to be applied on your main data. Without any measure the tables won't get picked up to your filter context.

         

        The tables need to be disconnected otherwise when you do the filter by one of the tables the result will get blank out on the other 2 tables.

         

        The measure I present does that filtering using the OR  - ||  condition and picking up the values you need.