Hi everyone!
In the report I developed we have a map with different locations showing different metrics. This is the result we are trying to achieve: the user selects one location on the map and then navigates the report keeping that selection.
The map is a mapbox hexbins map and the idea is that users should be able to select one hexbin and then that selection should be somehow "memorized" as a normal slicer and filter all the other charts and pages of the report.
We tried different things:
- Bookmarks: the problem with bookmarks is that when I click on the button to change chart or page I lose the selection I made on the map
- Separate table: we created a table where we have all the locations and a 1 if that location is filtered. We then used the column of that table to filter other visuals inside other pages. The problem is that when I change page, I lose the selection I did on the map
- Drillthrough: this seems to be the most promising option, instead of navigating through all the different pages, we are trying to build a summary page where the users can go after making the selection in the map. Not what we wanted but we could live with this
Things we didn't try but maybe could be worth investigating:
- Power automate: I am not sure, but maybe it would be possible to select the hexbin on the map, then have a button that runs a power automate flow that could write back a table with the selection. Then this table would not be "re-calcualted" when we change page and we should be qable to use it as filter for the other pages.
- Custom maps different from mapbox with write back option: I read here https://learn.microsoft.com/en-us/power-bi/developer/visuals/selection-api that it is possible to select a point in a visual and notify the other visuals of this and basically change their state, but I am not sure if this will work also for visuals in other pages. Maybe I just misinterprated it.
Do you have any suggestion to achieve this or to solve the problems listed here?
Thank you,
Carlotta.
