Forum Discussion
Filtering Data Across Multiple Pages By Selecting Points From Visualisation
hello Pandangus
if you would like to move the filters from page visuals to other page, you can use the drillthrough feature.
this feature will allow any filters on a page to apply to other pages .
hope this helps you with your request.
best regards.
Hello Daniel29195
I really appreciate your response 🙂 I'm looking into your suggestion. Though, as far as I understand (please correct me if I'm wrong), drill through allows you to select one data point and transfer that filtering to a drill through page.
What I'm trying to achieve is the ability to filter all visualisations, across the whole report, by selecting as many data points, from many visualisations, from any page (or pages) of the report as the user sees fit, and these selections being maintained as the user navigates between all pages.
As the selections are maintained between pages, any other visualisation in the report may be affected by the user selection. This way the user can hone in on specific information on the fly.
Thanks for your suggestion.
Kindest regards,
Angus
unfortunately, what you are saying is correct
you cant drillthrough if you have many selections from different visuals,
im thinking about what if you can use :
url filter parameters.
you can check these .
thi way you can use the web url instead of drillthrough .
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
https://community.fabric.microsoft.com/t5/Desktop/Dynamic-URL-based-on-selected-filters/m-p/771929
https://powerbi.microsoft.com/en-us/blog/power-bi-report-url-filter-improvements/
i think this would work for your case,
since the web url can be set dynamically using DAX
so what you need to do, is check how to write the url with filters . i honestly think this would work .
NB :
it is not a straight forward solution but i think it would work ...