Skip to main content

Power BI

Under Review

Default Selected Slicer or Tile-By Value Configuration

Vote (3438) Share
Power BI User's profile image

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 09 Feb 2018 03:54:31

We're looking into this request, thanks for everyone's votes and comments. 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 (386)
Power BI User's profile image Profile Picture

f6e2f6ce 57c4-4e3e-ad12-ca06e32954c6 on 05 Jul 2020 23:46:23

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.

Power BI User's profile image Profile Picture

fa83fc4d 0132-44c0-99c9-9585957f6b87 on 05 Jul 2020 23:46:18

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.

Power BI User's profile image Profile Picture

179f3f0b 92e8-43c5-b119-f79126e905e4 on 05 Jul 2020 23:46:13

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.

Power BI User's profile image Profile Picture

9b85d839 c2db-40d7-aa7f-ccff74e99ae5 on 05 Jul 2020 23:45:36

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.

Power BI User's profile image Profile Picture

f045893e 20f7-47b4-9a3f-42aaab8b7f21 on 05 Jul 2020 23:45:32

RE: Default Selected Slicer or Tile-By Value Configuration

we need default slicers selection.

Power BI User's profile image Profile Picture

e4a4a807 815a-48cd-9150-92b8f9e2cd3c on 05 Jul 2020 23:45:24

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

Power BI User's profile image Profile Picture

96412314 a40b-424f-8c92-6ef3e90afe5e on 05 Jul 2020 23:45:21

RE: Default Selected Slicer or Tile-By Value Configuration

Please add this feature. My clients keep ask for it. Thanks

Power BI User's profile image Profile Picture

6b616cd1 f449-438a-bab6-9e48b8f1e187 on 05 Jul 2020 23:45:10

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

Power BI User's profile image Profile Picture

ed6758d2 0a0a-4035-96c0-01278e45aaa1 on 05 Jul 2020 23:44:58

RE: Default Selected Slicer or Tile-By Value Configuration

we need this feature , in Date slicer ,whenever the Dashboard will be opened by Customer it should show the min(date) in "Fromdate"field by default in slicer and "Todate" will show the current date,

Right now it is not possible in power bi desktop as i tried alott. Can anyone tell me is there any other way to show.
and if there is not any other way then this feature should be implemented in Power bi Desktop.

Thanks.

Power BI User's profile image Profile Picture

b641bb12 a613-4aec-908b-99ecf75d458a on 05 Jul 2020 23:44:50

RE: Default Selected Slicer or Tile-By Value Configuration

I agree with others. This is a fundamental requirement and it's surprising/disappointing this is not already available.