https://store-images.s-microsoft.com/image/apps.6002.14a5c576-47e6-4427-9245-685689ad752e.b7e7243c-a99d-44a0-98bd-b82816236b1b.15b58939-464a-416d-ba13-bba67216b9bb

Preselected Slicer

by Insiders.coop

Microsoft PBI Certified
(9 ratings)
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

At a glance

https://store-images.s-microsoft.com/image/apps.43442.14a5c576-47e6-4427-9245-685689ad752e.b7e7243c-a99d-44a0-98bd-b82816236b1b.85cbf0ff-6ad0-449c-a548-2823a0e9c675