Select row in table visual to filter results in map visual on another page

[oneofthedamons]

I have 2 tables, Device and OpenCellId.

Device.CellId is a foreign key on OpenCellId.CellId in a many-to-many relationship. OpenCellId contains the latitude and longitude coordinates for each CellId.

I have a table visual showing various fields of Device on one page of my report, from which I can select a row (which corresponds to 1 device).

If I create a map visual on the same page as the table visual, selecting a row in the table visual correctly filters the row/s for the map visual, so that the device's cell location is shown.

What I want to do is move the map visual onto a different page and have this work still, so that selecting a device in the table visual on one page shows its location on the map visual on the other page. I can't get this to work.

By way of a comparison, on a third page I have a decomposition tree visual. When I select a row on the table visual on the other page, the decomposition tree visual correctly shows where the device exists in the decomposition tree.

Why can't I get the map visual to work in the same way as the decomposition tree visual?

Any assistance appreciated.

[Anonymous]

It's important to note that you may be confusing 2 separate functions in PowerBI. What you are doing with the visual is highlighting, not filtering.

" In general, highlighting isn't filtering. In most visuals, highlighting doesn't remove the unrelated data. Instead it highlights the related data. The rest of the data remains visible but dimmed"

Filters and highlighting in Power BI reports - Power BI | Microsoft Learn

What Amitchandak has said should be useful. If you setup a Drill-Through option on your table visual that goes through to a page where the map visual is - the map visual should be filtered (not highlighted) by what datum was selected on the table visual. This will, in essence, allow you to filter to that specific datapoint, and access the map visual on a different page.

[amitchandak]

@oneofthedamons , I think drill through should help

Power BI Drill Through - More than one level: https://www.youtube.com/watch?v=hCAAvpppQmk

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough