Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Pandangus
Frequent Visitor

Filtering Data Across Multiple Pages By Selecting Points From Visualisation

Hello all,

   I’m recently in a new job role and have immediately been tasked with rebuilding a multipage Qlik report in Power BI.

 

   A key feature of the original Qlik report enables the user to freely select data points within the visualisations which applies a filter, alters the underlying data model, and impacts all relative visualisations across all pages of the report. These selections then remain in place until they are deselected. Even when navigating between pages, the selection remains in place and affects all other pages accordingly. Much like a synced slicer.

 

   For example; in a 'Number Of Orders by Month' column chart,  the user could select the 'August' column. This would then appropriately affect the 'Number Of Orders by Day of Week' visualisation and 'Orders by Day Of Month' visualisation, on other pages, to only show data from the month of August (as well as all other related visualisations across the entire report).

 

   I’m trying to recreate this behaviour in Power BI, but so far the only workaround I’ve found is to create a bookmark and button for every possible data point in every single visualisation across the entire report, or to exclusively use slicers to implement these visualisation changes.

 

   The former of these solutions is impractical to the degree of being unworkable, and the second solution doesn’t achieve the user experience I’m supposed to be recreating. I’m beginning to wonder if this is even possible in Power BI, but I hold out hope that there’s a solution to this.

 

   If anyone can shed any light on this matter I’d be forever grateful! A suggestion, solution, explanation of how I'm not getting it, or even outright confirmation that it’s not possible would be much appreciated 🙂

I only hope I've articulated my problem sufficiently.

 

Kindest regards,

Angus

4 REPLIES 4
Daniel29195
Super User
Super User

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

@Pandangus 

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/

 

Daniel29195_0-1705666914229.png

 

@Pandangus 

i think this would work for your case, 

since the web url can be set dynamically using DAX

Daniel29195_1-1705667022331.png

 

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 ...

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors