The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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 ...