Skip to main content
Microsoft Idea

Power BI

Planned

Default Selected Slicer or Tile-By Value Configuration

Vote (5615) 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 (524)
Jacek Power BI User's profile image Profile Picture

Arjun on 06 Jul 2020 00:17:00

RE: Default Selected Slicer or Tile-By Value Configuration

I have a month slicer (Jan, Feb, Mar, ...) and a year slicer (2020, 2021, ...)
I want the current month and year to be selected by default after the report refresh. But the user should be able to select previous months and years also.

I cannot use a relative date slicer as it is confusing to the user.
This feature is definitely a must in any BI Platform with automated data refresh.

Jacek Power BI User's profile image Profile Picture

Craig Bryden on 06 Jul 2020 00:16:51

RE: Default Selected Slicer or Tile-By Value Configuration

We need this to be programmable. Maybe have a DAX measure that returns the default value that should be selected. As an example, select the user's department by default, while still leaving the other selections available.

Jacek Power BI User's profile image Profile Picture

jake on 06 Jul 2020 00:16:44

RE: Default Selected Slicer or Tile-By Value Configuration

Can you please also add the forced selection like currently available in chiclet slicer, its very much needed? Thanks in advance for help.

Jacek Power BI User's profile image Profile Picture

Mariia on 06 Jul 2020 00:16:36

RE: Default Selected Slicer or Tile-By Value Configuration

Voting for this idea because I need to show data from first day of current month till the last date in the date field by default and also provide users with ability to move left circle to see historical dates. I'm using slicer with "between" option and I can't set first day of the month (or today () , for example) as a date for left circle by default.

Jacek Power BI User's profile image Profile Picture

Elaw Justin on 06 Jul 2020 00:16:25

RE: Default Selected Slicer or Tile-By Value Configuration

How many votes are required for an idea to approved ?

Jacek Power BI User's profile image Profile Picture

Gary Smith on 06 Jul 2020 00:15:54

RE: Default Selected Slicer or Tile-By Value Configuration

Upvote. This should be standard functionality

Jacek Power BI User's profile image Profile Picture

Laurens SNoek on 06 Jul 2020 00:15:34

RE: Default Selected Slicer or Tile-By Value Configuration

Any update?

Jacek Power BI User's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:15:18

RE: Default Selected Slicer or Tile-By Value Configuration

Anyone from Microsoft can comment on the status?

Jacek Power BI User's profile image Profile Picture

Matt Hamann on 06 Jul 2020 00:15:09

RE: Default Selected Slicer or Tile-By Value Configuration

Can Power Bi give an update on the status of this? I need a report to default to current year and current pay period, out of a query that is generated every week. Right now the report consumers need to select the year and current period. The VP's want it to default to current on both hence the request. So right now for instance we would want year 2020, and period 22 selected in the slicer.

Jacek Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:15:01

RE: Default Selected Slicer or Tile-By Value Configuration

I would really like to see the ability to use a start and end date slicer, but that can default to a preselected date range such as the current month to date. Many users would still like the ability to view any date range, even if the report opens with the current month. Right now, it's not possible to have it both ways.

Merged Idea (15)