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)
- Merged Idea (15)
RE: Default Selected Slicer or Tile-By Value Configuration
This is such a no brainer feature. Hard to believe they haven't already created it.
RE: Default Selected Slicer or Tile-By Value Configuration
This feature is very helpful as it gives default date selection when power bi report opens first time on the service and if user want he can change this setting too on the report itself.
Its very important feature..!
RE: Default Selected Slicer or Tile-By Value Configuration
I have been developing SSRS reports for many years now and each parameter has an available values AND default values selection. The most common use case is for time period selection e.g month. Every time the user runs the report the latest months data is automatically displayed. Yes you can do this in Power BI with the realtive date slicer BUT what if your fact table for whatever reason has the latest month that is not the current month and cannot be determined by Last x in the relative date slicer. In SSRS it was easy: SELECT MAX(DateKey) from FactPleaseAddThisSoon.
Also even though you might be able to use the Relative date slicer, what if you want to have a drop down or list slicer.
I have also tried the well documented flagging the current month but its not very nice having a slicer thart reads Jan Feb Cur April May....
Please nice Power BI people, its been three Christmases now and we still have not received this present!
RE: Default Selected Slicer or Tile-By Value Configuration
I have a date slicer where I can choose a date range. Basically, I need to set "TODAY" as default finish date, but still being able to select other dates.
RE: Default Selected Slicer or Tile-By Value Configuration
Sticky filter selections were added nearly a year ago. If you set the slicer to 180 days and publish, will this set the default for your users?
RE: Default Selected Slicer or Tile-By Value Configuration
As already mentioned, for lists and drop downs, there are two big issues at the moment:
1) If single select is enabled then you should not be able to unselect your item and have it show All. The slicer should force the user to select a different item.
2) For default values, sticky filters is not a solution as due to RLS different users may have different selection options. One possible and seemingly easy solution would be to have a 'default to first/last' option.
I am loathe to start a new idea when this is officially under review, so I hop these quick wins will be taken on board.
RE: Default Selected Slicer or Tile-By Value Configuration
Has there been any movement on this? We really need the ability to programmatically set the default value for our date based slicer.
RE: Default Selected Slicer or Tile-By Value Configuration
This idea was submitted Apr 26, 2017. Approaching two years and no response from Microsoft.
RE: Default Selected Slicer or Tile-By Value Configuration
I would need something that says most recent fiscal period or week, not standard calendar
RE: Default Selected Slicer or Tile-By Value Configuration
This is a feature we need for sure.