Forum Discussion
Text Slicer filter
- Anonymous1 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.
Thanks again amitchandak. I am new to PowerBI so I am unable to make your example work on my end. Do you have a more detailed example? Thanks!