Switch to another tab with filtered data using a hyperlink

[Anonymous]

Hi all,

I want to filter my dataset and then switch to another tab with it's related ID and see the values which belong to it. I wanted to try this with a hyperlink in a text box, but it doesn't use the filters and will open the whole report again instead of switching tabs. Does anyone know how to fix this?

(The data is based like this: let's say I have a specific brand of clothes the production site is displayed in a map. If I click on my hyperlink I want to switch to the other tab to see the shops where they are sold. The ID from the production site and seller site are the same and are connected)

[amitchandak]

@Anonymous , refer if this can help

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Cond_dest_drill

[mahoneypat]

The functionality you are describing is called Drillthrough.  Please see this link to see how to set it up in your model.

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

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat