Skip to main content

Power BI

Needs Votes

Create a Parameter Slicer that refreshes queries on selection

Vote (43) Share
Jeff's profile image

Jeff on 24 Nov 2016 00:30:04

It would be incredibly valuable to have a new slicer type that connects to user defined/ query defined parameters lists and has the ability to refresh queries after a selection is made.

You would be able to define a list of parameters - make a selection from a slicer and have your data sources be refreshed utilizing that parameter - without having to click refresh all - which might be more refreshes than are needed.

Comments (3)
Jeff's profile image Profile Picture

Power BI User on 06 Jul 2020 00:16:22

RE: Create a Parameter Slicer that refreshes queries on selection

This is very basic functionality not available. The Pro version supports only 8 times refresh of dataset per day. it means minimum data frequency is every 3 hours. Customer can't for 3 hours to refresh the data. The slicer only works with import query mode. It does not allow end user to filter data in direct query mode. This functionality will allow end user to filter data manually using slicer and refresh only required chart.

Jeff's profile image Profile Picture

Edmond on 05 Jul 2020 22:35:09

RE: Create a Parameter Slicer that refreshes queries on selection

agreed

Jeff's profile image Profile Picture

eugene on 05 Jul 2020 22:35:08

RE: Create a Parameter Slicer that refreshes queries on selection

That's Rad - super useful