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! 🙂

Hariharan_R's avatar
Hariharan_R
Solution Sage
4 years ago

Hi Anonymous 

Build one date table and connect them through date column like below. if you use the date table date column in slicer then table 2 results will automaticlly filtered for the selected date.

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin