Global filter in dashboards
Allow me to pin a filter to the dashboard that can be associated with one or more pinned dashboard KPIs.
We don’t plan to bring filters to dashboards. We do plan on investing more in composite models to allow multiple sources to be brought into the same report for slicing and filtering.
Too bad ! Very important feature, dashboard are just useless without this possibilty !
wow...was going to use the dashboard feature for an upcoming project but if you cant even apply any global filters (date range being most important) we will have to look at alternatives
In a similar vein we have ‘Live’ pages on dashboards that have slicers to allow users to focus on their preferred Geographical Regions. These slicers do not persist between viewing of the dashboard which seems an oversight given that this feature was added to reports some months ago.
Are dashboard features are being overlooked? Seems odd given that they're the obvious starting point for users interaction in a PowerBI session!
Please reconsider this issue and making dashboard filters persistent.
Please reconsider adding this
PLEASE ADD THIS. my reports are meaningful without global toggles.
Please add this
"Please explain how Power BI could possibly be used for centralised reporting in this state. Am I meant to just create endless duplicate reports for each filter needed?"
My thought exactly...
I can't believe this product was recommended to me, it is completely impossible to make dynamic reports with data from multiple SSAS data sources... which was my only goal O_O
What a waste of time...
How am I supposed to have director level summary dashboards if I can't filter!? I can't use a "report of reports" since they do not sync and it looks like MS has no plans to make them sync. Please explain how Power BI could possibly be used for centralised reporting in this state. Am I meant to just create endless duplicate reports for each filter needed?
absolutely need a filter option in the dashboard. make or break option.
We display push datasets using Power BI dashboards to show near real-time information to our customers. This use-case will certainly become more common in the future.
We cannot use reports or pin live pages. These do not update as new data is received.
Imtiaz Hussain commented
@ Kim - Hi, so does your answer mean MS is essentially giving up on improving dashboards?
John B. commented
This is a make or break feature for our project. We have hundreds of individual reports that need to be combined into one dashboard and pre-filtered via query string parameters in programmatically generated hyperlinks.
Kurt Dhaene commented
Go for it
I agree with others on this forum - this feature should be added. As simple as that.
Franklin Edwards commented
After trialling building a dashboard in Power BI I am surprised to find out this feature doesn't exist for dashboards but inexplicably does for reports. I've passed this on to my management and will now be using Qlik sense for this (which support global filters) and future dashboard development pieces. Also we're cancelling our pro subscriptions since there's little point in having them. I would love to understand better the rationale for not providing this feature but am too time poor to investigate as I have to rebuild a dashboard
Bill Ritchie commented
This feature is a MUST for Power BI, if it's Dashboard is to function as all other competing products. Even the simplest of cloud-based dashboard products have such a feature...see Klipfolio, Tibco, and others. Please reconsider this suggestion. Without this functionality, as others have mentioned, the "Dashboard" feature is very weak. This seems like a very simple fix...as you are applying a feature that is already in in the "Report" views under the "synchronize slicer" check-box. There are a LOT of users out there who would like to create a dashboard that reflects multiple KPIs based upon a single selection criteria (including my university students) : - )
I assumed this would be part of the dashboard. Made three 'tiles' or pages, had a slicer in each one for each site I manage, then found the 'Sync Slicer' option and it worked great. Within PowerBI desktop.
However, when i made a dashboard out of the three tiles, the two that had the hidden synced slicer did not update. They actually only show the last published version from PowerBI desktop and don't even change with the tile being refreshed within the service.
It seems strange to allow synced slicers across multiple pages within a report, but not allow those sliders to update the full dashboard. This would really be helpful, the only other way around it is to make the dashboard look clunky by adding the slicer back to each of the three tiles.
Please add this functionality!
Dashboards are faster when a report needs to show a lot of data and visuals. I originally tried a custom page size 10 times longer than wide, filled it up with everything I needed and it was very...very ...very slow. Scrolling down the page was basically impossible and that was using a premium workspace. I had to move to multiple pages in the report using a synced slicer. Moving those pages back to the dashboard using the pin live page made scrolling through a full report much easier...BUT...this is where the synced slicers across the dashboard would come in handy. If you can't do the synced filters then maybe you could at least pass through the last users filter selection like what is done now. In my example, I create a common report for multiple markets across the country. Each market could go into the Report directly and set their market filter. It stays on their last selection when they come back to the report, it should be a minor thing to pass that same stored selection to the dashboard when they open it. Right now filter selections that get pass with the live page are the defaults selected when the report was last editied.
Ryan Paquette commented
Having this functionality seems obvious... a no brainer. Yet the Idea is closed with no plans to ever do it... seems odd.