Skip to main content

Power BI

Planned

Default Selected Slicer or Tile-By Value Configuration

Vote (5661) Share
Jacek Power BI User's profile image

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 (527)
Jacek Power BI User's profile image Profile Picture

Sukhomoy Bhattacharya on 05 Jul 2020 23:14:51

RE: Default Selected Slicer or Tile-By Value Configuration

Conceptually, "Select All" means there will be no filter. On other hand, Select All = Off suppose to be at least one filter.
According to Power BI, Select All = on means one more item name "Select all " will appear in slicer list, I believe is actually not require, as if you don't select any option in Slicer list means there is no filter.
On other side, if I choose option Select All = Off then there should be another option Default Value. Where I can select a default Value for that context.

Jacek Power BI User's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:14:25

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.

Jacek Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:14:19

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.

Jacek Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:14:19

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.

Jacek Power BI User's profile image Profile Picture

Mrinal on 05 Jul 2020 23:13:49

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.

Jacek Power BI User's profile image Profile Picture

aditya yadav on 05 Jul 2020 23:13:45

RE: Default Selected Slicer or Tile-By Value Configuration

This will be a very good addition in the upcoming versions.

Jacek Power BI User's profile image Profile Picture

Mollie on 05 Jul 2020 23:12:44

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.

Jacek Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:12:19

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.

Jacek Power BI User's profile image Profile Picture

Chad Thurston on 05 Jul 2020 23:10:48

RE: Default Selected Slicer or Tile-By Value Configuration

'@Lucas Sutherland could you expand on your workaround?

Jacek Power BI User's profile image Profile Picture

Mahmoud Sameer on 05 Jul 2020 23:10:39

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

Merged Idea (15)