Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to filter a table based on user input?

Example - if a user inputs date (from table 1), I need to filter table 2 by displaying all the rows which have the range of date to date - 13.  I created a slicer and now I take the value that is ...
Need Help
  • rohit_singh's avatar
    rohit_singh
    4 years ago

    Hi Anonymous ,

    No worries. Yes that can be done. 
    Just create a new measure like below :

     

    _val =

    var _sel = SELECTEDVALUE(dates[Dates])

    var _cond = if (MAX(SampleData[Date]) >= _sel-13 && MAX(SampleData[Date]) <= _sel , 1, 0)

    return
    _cond
     
    Then add this measure as a filter on the visual and set its value to 1

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Also, if I had to save this filtered table and then join with another table and display that in the report - can I do that?
so, everytime a user selects a date, I filter the table and perform a join with another table and display that in the report. Is this possible?

 

rohit_singh's avatar
rohit_singh
Solution Sage
4 years ago

Hi Anonymous ,

You don't need to save the table. You can smply create a relationship between Table2 and the other table and drag and drop columns from the other table into your visual. The values in the otehr table will be filtered automatically based on the relationship you've created.

Kind regards,

Rohit