Forum Discussion
Filter dates based on other value
Hi Daiov97,
If you make a slicer with your "Dates" column as value, you can filter with dates. If you select a single day through the slicer it will display all data from that day. All visuals will interactively only show data from that day, so map visuals will show all locations from that day like you wanted.
Please let me know if you need more help.
Regards,
L.Meijdam
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.