The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have the following filter setup (see picture). All filters are connected to Dynamic M Query parameters. I want to add a button or something similiar that activates the filters. This is the functionality I want:
User select filters --> nothing happens (i.e. the query does not update)
User hits button "Execute" --> Query is updated based on filter values and chart uppdates
Is this possible, and if so how?
Report setup:
As to why I want to do this: Filter 1/ Filter 2 are closely connected and it does not make sense to chose only one of those. Also if only filter1 is active, the query will exceede 2mill rows. It is also a much better user experience to have the chart update only after selecting all relevant filters, rather than having it updating while you're not done selecting filters. Similarly the chart will fail if the query exceedes the 2mill row limit in PBI, which is why you would only want it updating if the filter values are valid (returning a query within the size limitations of PBI).
Furthermore I want to have the Activate/Excecute functionallity apply to individuall filters, for example one button for each filter.
Solved! Go to Solution.
See if this setting for a single Apply button will meet your requirements:
Proud to be a Super User!
See if this setting for a single Apply button will meet your requirements:
Proud to be a Super User!
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 June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |