Filter dates based on other value

[Daiov97]

I'm new to power bi and wondering if there's a way to make this work:

I have a table with dates, coordinates and another column with a value in it.

I want to show all the locations on that specific day. When I try to filter the column with the value, the visualisation "route map" only shows the specific location of the filtered value.

Is there a way to show ALL the locations on that day?

[Anonymous]

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

[Daiov97]

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.

[v-yulgu-msft]

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