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 (535)
- Merged Idea (15)
RE: Default Selected Slicer or Tile-By Value Configuration
I have a slicer which I want to default to the user's name, with the slicer field being a list of other user's names, so it would be helpful if the slicer's default could be set via the value of a measure.
RE: Default Selected Slicer or Tile-By Value Configuration
This idea show's "under review" since Feb 8, 2018. Any closer to making this a reality?
RE: Default Selected Slicer or Tile-By Value Configuration
This is a basic requirement. Customers want to have a default value but also wants to have all others values available.
RE: Default Selected Slicer or Tile-By Value Configuration
We need the ability to use a date range (not relative dates) and to set default values programmatically. Relative dates rarely give our users what they need and sticky filters don't resolve this at all. Date ranges that are stuck as a default end up stale for old date ranges. Using Power BI Report Server.
RE: Default Selected Slicer or Tile-By Value Configuration
Hi we have requirement to have default value in the slicer like current month and show rest of the months in the drop down. Please implement this because of this feature we are not able migrate our reports from obiee to power BI.
Functionality: Set Default value in the slicer as current quarter and the dropdown should show rest of the quarters.
**Slicer should have option to set default value based on another column or by using parameters or DAX function.
RE: Default Selected Slicer or Tile-By Value Configuration
Why it is taking too long to implement such a nice and simple feature. At lease give an option to select max/min/first/last value of any data type.
RE: Default Selected Slicer or Tile-By Value Configuration
we need default slicers selection.
RE: Default Selected Slicer or Tile-By Value Configuration
Please implement this one as this is required in many of dashboards , users always want default slicer to be fromdate to Today
RE: Default Selected Slicer or Tile-By Value Configuration
Please add this feature. My clients keep ask for it. Thanks
RE: Default Selected Slicer or Tile-By Value Configuration
What's the status with this? It's an imperative piece of functionality and we will be moving BI providers if we can't achieve