Preselected Slicer image

Preselected Slicer

by Insiders.coop

Microsoft PBI Certified
Download SampleInstructions

The Preselected Slicer is a slicer for Power BI where values can be pre-selected by your data.

Use the Preselected Slicer in your Power BI reports to filter other visuals with one of your dimensions, like with a regular slicer. The advantage of the Preselected Slicer is that you can use another column or measure to tell which values must be pre-selected when a user opens the report. Then, instead of modifying the report each time you need to change the default selection, the model will tell the Preselected Slicer which is the default selection. Let's say you have a report with different visuals. You would like to display your charts filtered by the current year or month by default. You can do that with the Preselected Slicer. Your users will still be able to filter on other years or months by changing the current selection. Note: The Preselected Slicer needs a third "technical" measure in order to keep its dirty status updated cross pages.

Visual capabilities

This visual is certified by Power BI
By getting this product, I give Microsoft permission to use or share my account information so that the provider can contact me regarding this product and related products. I agree to the provider's terms of use and privacy policy and understand that the rights to use this product do not come from Microsoft, unless Microsoft is the provider. Use of AppSource is governed by separate terms and privacy.