Skip to main content
Microsoft Idea

Power BI

Planned

Default Selected Slicer or Tile-By Value Configuration

Vote (5573) Share
Jacek Power BI User's profile image

Jacek Power BI User on 03 Mar 2015 07:53:52

Allow a user to set the default value for a slicer or tile-by value on a page/dashboard, so that when the Power View page is opened for the first time, the default value is selected.
eg. If the page has a slicer for Year or Month, allow the user to configure the most recent Year or Month to be selected by default.

Administrator on 20 Oct 2022 22:52:37

Update 10/20/2022 - Update from Mo - we are working on this in the new year

Thanks for everyone's votes and comments. This is a feature on our backlog; however we cannot share a timeline at the moment.

It looks like many of the requests will be addressed by the new 'Sticky filters' capability. Now when you log out of Power BI and come back to a report, the same items will be selected as when you left. For those who're looking to have a 'last month' selection, the relative date slicer might help. Those with comments about currencies where having multiple selected makes the report meaningless - the report will load with whatever selection the author saved, so if you save it with one currency selected your users will see that by default. If there are scenarios that these features don't address, please let us know in your comments - if you are really specific it'll help us build the feature to work just the way you want! Thanks again!
 

Comments (528)
Jacek Power BI User's profile image Profile Picture

himovies plus on 04 Apr 2024 02:32:49

RE: Default Selected Slicer or Tile-By Value Configuration

I have the same question, thanks

Jacek Power BI User's profile image Profile Picture

Trevor White on 27 Mar 2024 21:01:47

RE: Default Selected Slicer or Tile-By Value Configuration

If you set the default slicer in the theme the UI doesn’t respect it you have to open the slicer and press the set to default button then it will use your theme settings.

Jacek Power BI User's profile image Profile Picture

Sara A on 24 Mar 2024 22:55:19

RE: Default Selected Slicer or Tile-By Value Configuration

When using a slicer with hierarchy values, it is not possible to set default value. there is not even workaround to achieve this.

When we use date hierarchy slicer and open the report, we need to set it to current date when report is open which is not possible.

Jacek Power BI User's profile image Profile Picture

Laurence S on 14 Mar 2024 19:47:52

RE: Default Selected Slicer or Tile-By Value Configuration

Hi Kieran, thanks for posting the video below. It can't come soon enough!

Jacek Power BI User's profile image Profile Picture

Kieran Leigh on 01 Mar 2024 13:38:26

RE: Default Selected Slicer or Tile-By Value Configuration

For those looking for an update, you can see this recent live stream:


https://www.youtube.com/watch?v=uyvOBtobWeE


The short version is that it is being worked on, but some infrastructure work needs to be done first.


Key timestamps:

  • 16:40 - a new dashboard will be made public, this will provide better updates on ideas being worked on.
  • 1:07:45 - update on what's happening with this feature in particular.
Jacek Power BI User's profile image Profile Picture

ash ketchum on 24 Feb 2024 19:04:44

RE: Default Selected Slicer or Tile-By Value Configuration

Jacek Power BI User's profile image Profile Picture

Iara Schiavon on 16 Jan 2024 13:04:21

RE: Default Selected Slicer or Tile-By Value Configuration

To Power BI users everywhere: Please let Microsoft know the product is not really functional without slicers that can be preselected intelligently. For example, there is no way to preselect the most recent month (in a way that allows other date ranges to be selected). Yes there are ridiculous workarounds that take huge amounts of effort and don't really work.

Jacek Power BI User's profile image Profile Picture

Martin K. on 15 Dec 2023 07:01:14

RE: Default Selected Slicer or Tile-By Value Configuration

The sticky filter is not enough.

You need to make it possible for the business owner to direct what the report audience shall see when opening the report and/or resetting the report filters in order to focus on the desired "time window" etc.

In addition to making it possible to set default values, make it possible to set a new option "mark as date slicer" on/off, and thus enable the Date Filtering options in the slicer visualization.


One angle is simply put to move the existing filter pane options to the Slicer Visualization Options.


So, add the options:

  1. Set as default value (when opening/resetting/refreshing)
  2. Mark as date slicer
Jacek Power BI User's profile image Profile Picture

Pat Littleton on 01 Dec 2023 15:28:41

RE: Default Selected Slicer or Tile-By Value Configuration

To Power BI users everywhere: Please let Microsoft know the product is not really functional without slicers that can be preselected intelligently. For example, there is no way to preselect the most recent month (in a way that allows other date ranges to be selected). Yes there are ridiculous workarounds that take huge amounts of effort and don't really work.

Jacek Power BI User's profile image Profile Picture

Laurence S on 14 Nov 2023 15:15:38

RE: Default Selected Slicer or Tile-By Value Configuration

To Power BI users everywhere: Please let Microsoft know the product is not really functional without slicers that can be preselected intelligently. For example, there is no way to preselect the most recent month (in a way that allows other date ranges to be selected). Yes there are ridiculous workarounds that take huge amounts of effort and don't really work.


Merged Idea (15)