Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Text Slicer filter

I would want to implement a different sort of a "From-To" slicer using texts instead of dates and was wondering if this is possible.   Here is the scenario: Working in an agile environment, I have...
  • Anonymous's avatar
    Anonymous
    1 year ago

    I was able to find a way to resolve my issue.  Not sure if this is the best way to do it but it works for me. 🙂
    I want to share what I did in case someone is in the same situation.

     

    I created a duplicate of my sprint tables and made them disconnected as amit suggested (for discussions sake, let's name them "FromTable" and "ToTable" tables).  Then I created a measure on the "ToTable" table similar to the one below:

    From_Start_Flag = IF(VALUES(ToTable[Start Date]) >= SELECTEDVALUE(FromTable[Start Date]), 1, 0)

    I then used the From_Start_Flag measure as a filter on the ToTable so that it will exclude dates earlier than the FromTable.

     

    I also created a similar measure on the visual's table to filter out by Start Date as follows:

    SprintRange_Flag =
    IF(VALUES(UserStories[Start Date]) >= SELECTEDVALUE(FromTable[Start Date]) && VALUES(UserStories[Start Date]) <= SELECTEDVALUE(ToTable[Start Date]), 1, 0)

    I then added that measure as a filter on the visual.

     

    There you go.  I hope this helps someone.