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 09 Feb 2018 03:54:31
We're looking into this request, thanks for everyone's votes and comments. 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 (386)
RE: Default Selected Slicer or Tile-By Value Configuration
I teach all my users (not techsavy at all) to return to default settings after opening the report, because they forget what they have filtered (and get confused).
How nice would it be if at least my year and month would return to the current month setting (instead of the hardcoded current year and January because I don't want to republish every month).
RE: Default Selected Slicer or Tile-By Value Configuration
Setting default values for slicers is a nightmare in Power BI. This is probably the biggest miss in the tool.
RE: Default Selected Slicer or Tile-By Value Configuration
Please make it happen! The relative date slicer is confusing and doesn't address many cases. We need a DEFAULT value for FILTERS and SLICERS based on a free DAX formula.
Thank you!
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.
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.
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.
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.
RE: Default Selected Slicer or Tile-By Value Configuration
How many votes are required for an idea to approved ?
RE: Default Selected Slicer or Tile-By Value Configuration
Upvote. This should be standard functionality
RE: Default Selected Slicer or Tile-By Value Configuration
Any update?