Forum Discussion
Filter dates based on other value
Thanks for your response.
I already figured out how to use a date filter. My problem is more complex. I created a table to show my issue:
What I tried is filtering all the lines with the value "this". When I do this in the table above, it will show me 3 lines.
I want to show all the locations on that day and not only the one where the value is 'this'. I want it to show the second line (with test as value) as well, because that date is the same as the one above.
When i filter on the dates manually, Power BI will pick all the dates from all the persons. If personID 1 has made a trip with the value 'this' on a specific day, the whole day has to show up in my visual.
I don't know if it's possible, but I hope I made my issue clear. It's pretty hard for me to explain what I want.
Hi Daiov97,
This is not achievable. Once you apply a slicer filter to table visual (e.g this), the current context only contains three rows (line 1, 3, 4). It is not possible to access other rows which has been excluded.
Regards,
Yuliana Gu