The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
A customer asked me if it is possible to have a world map, visualizing all countries they represent, and use that map as a filter for the whole report (thus as a report level filter). Is this possible? In addition they would like to have other visuals or eventually basic filters that act as report level filters.
It would really be a showstopper for the customer if they would have to reset all filters again and again on each page of the report.
Thanks in advance!
Solved! Go to Solution.
Right now, the only way to have a filter apply across the report is through Report Level filters. So unfortunately, the answer to your question is no.
Right now, the only way to have a filter apply across the report is through Report Level filters. So unfortunately, the answer to your question is no.
Ok I was already afraid for that. Think the customer will not choose for PowerBI then. I posted an idea for this.
It now works for me, may have been an update since this original post. I have the country field used on the map also set as the Report level filter and Page level filter. All you have to do then is make sure that the Filter icon at the top right of each visual is selected rather than the default Highlight (Pie symbol).
@TytlerJaxon yes, you need to adjust the filter icon at the top right to define the visual as the page level filter. But how did you manage to let it filter all other filter (i.e. making it a report level filter)? It seems like I'm not able to do that.
Ahh I see, you mean to apply a filter on one page that works for other elements pages as well? Then apologies, there doesn't appear to be a way that I can see. It's a shame as I know Qlik Sense Desktop has this capability and I find it very useful especially for country level analysis.
One slicer to set filters for a set of pages (to be set in the slicer configuration pane) would, indeed, be VERY helpful.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
82 | |
77 | |
46 | |
39 |
User | Count |
---|---|
137 | |
108 | |
69 | |
64 | |
53 |