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 (523)
- Merged Idea (15)
RE: Default Selected Slicer or Tile-By Value Configuration
Can we have the updated date by when this option will be given in Desktop tool as many clients demands that any one value can be mentioned as default from the listed all values from slicer and based on mentioned default value , the report should load 1st time.
RE: Default Selected Slicer or Tile-By Value Configuration
This will be a very good addition in the upcoming versions.
RE: Default Selected Slicer or Tile-By Value Configuration
This is a related request, but not exactly the same. It would be great to be able to force a selection in a filter using the slicer. I'm working with data of various regions where the aggregation doesn't make sense if there is no region selected (i.e., percentages that shouldn't be added/averaged/etc.). I have been using the customized Chiclet app to do this, but given the new syncing feature of slicers across report pages (that doesn't work with the Chiclet app), it would be great to be able to force a selection in the slicer native to Power BI.
RE: Default Selected Slicer or Tile-By Value Configuration
Please add this feature, it is a must needed feature for client and somewhere it became a bottleneck.
RE: Default Selected Slicer or Tile-By Value Configuration
'@Lucas Sutherland could you expand on your workaround?
RE: Default Selected Slicer or Tile-By Value Configuration
I suggest to edit the slicer to be like the filter in the SSRS i.e to be able to add default selection as well as if no item selected the report should not select "All" by default as happen now
RE: Default Selected Slicer or Tile-By Value Configuration
We need this feature urgent! Please
RE: Default Selected Slicer or Tile-By Value Configuration
In desperate need of this. Without this, a lot of the slicers i have in my reports render useless. Could you please implement this!
RE: Default Selected Slicer or Tile-By Value Configuration
This Idea is extremely important for my clients
it is basic in a bi tool
RE: Default Selected Slicer or Tile-By Value Configuration
Ideally would be able to set the default value of a filter based on another value, e.g., select year where 'Is Current Year' equals 1.