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 (526)
- Merged Idea (15)
RE: Default Selected Slicer or Tile-By Value Configuration
It should be possible to have a slicer with dates to select, but that, while always displaying a relative list of dates (say the last 30 days), it should default to the "current date", as flagged by a different field in the table/dimension.
The relative list of days works fine with the relative date slicer option, however the default selected value does not seem possible to set at present.
RE: Default Selected Slicer or Tile-By Value Configuration
There are multiple ideas for this that someone needs to consolidate. This is such a basic reporting requirement that we shouldn't have to use bookmarks or other filters to get around.
RE: Default Selected Slicer or Tile-By Value Configuration
Please just simply add the ability to have a dynamic date default selected like in SSRS. This is a standard reporting requirement that should have been solved before relative filters or bookmarks were added.
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