Skip to main content

Power BI

Planned

Default Selected Slicer or Tile-By Value Configuration

Vote (5663) 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

Pilar Sastre on 05 Jul 2020 23:59:08

RE: Default Selected Slicer or Tile-By Value Configuration

I need to be able to default a date slicer to a "Current (time period)". And then give the user the ability to select another non-default item from the slicer, but it should default to the specified value when opened/reset.
This is highly needed!
Thanks!

Jacek Power BI User's profile image Profile Picture

Braden on 05 Jul 2020 23:59:05

RE: Default Selected Slicer or Tile-By Value Configuration

Yes, this idea is critical. For example there are some reports where we would love to default the department to that user's department automatically. Having the ability to dynamically change the default would solve this. Similar to how it works in SSRS, you can return the value you want to use in another data set. I foresee where in Power BI you could do something similar. We have attempted to use Row level security and work around it by basically populating a table with every single possible slicer value for every user and then just setting the default to "My Dept." or something like that...but it's not very salable as more users start.

Jacek Power BI User's profile image Profile Picture

Joanna on 05 Jul 2020 23:58:56

RE: Default Selected Slicer or Tile-By Value Configuration

I would need to be able to default the slicer to a certain period, for example the prior period. I still need to have an option to select other periods as needed. The reason is that the previous period is needed 95% of the time, but the remaining 5% of the time they the user would look at other periods.

Jacek Power BI User's profile image Profile Picture

Amine Bouhouche on 05 Jul 2020 23:58:47

RE: Default Selected Slicer or Tile-By Value Configuration

This is a very important request

Jacek Power BI User's profile image Profile Picture

Helena Sjöberg on 05 Jul 2020 23:58:41

RE: Default Selected Slicer or Tile-By Value Configuration

I would need a default for last month or quarter but without using the relative date filter.

The reason is that the users need to be able to select a specific quarter years back while still allowing the report to always display the current quarter. While a relative date slicer solves the later it means that we need to add another date slicers that the users need to uncheck revert time they want to go back to say Q2 2017.

Jacek Power BI User's profile image Profile Picture

Jill Nabonsal on 05 Jul 2020 23:58:22

RE: Default Selected Slicer or Tile-By Value Configuration

This is critical.

The only workaround for now is to change the slicer value each day/week/month/year, save and republish. In a controlled production environment requiring a Change Request to promote production changes - too much operational overhead. Must address.

Jacek Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:58:21

RE: Default Selected Slicer or Tile-By Value Configuration

This is a critical update in my opinion.

Jacek Power BI User's profile image Profile Picture

Andres Martinez on 05 Jul 2020 23:58:21

RE: Default Selected Slicer or Tile-By Value Configuration

Many customers are asking about Synchronizable Calendar Slicers where you can default to yesterday's day for example. And have a Calendar Widget to choose 'ONE' day only, instead of a pair of dates.

Jacek Power BI User's profile image Profile Picture

Andres Martinez on 05 Jul 2020 23:58:20

RE: Default Selected Slicer or Tile-By Value Configuration

Another request is to be able to pass a date parameter to the Sync Calendar control and determine current value for the date(s)

Jacek Power BI User's profile image Profile Picture

Tony Taylor on 05 Jul 2020 23:58:09

RE: Default Selected Slicer or Tile-By Value Configuration

Could we get a new format category (General/Selection controls/ DEFAULT VALUE / .) on slicers, which allows for a value/formula/based on another field. to define the default. Eg. default value = value in this field (CurrentFY = "FY2019/20"); if default value field doesn't match a value in the slicer list, no valid default.

Relative date slicers don't work for financial years when they differ from the calendar year. We flag the Current Day/Week/Month/Financial Year time period with a column (physical/calculated/measure doesn't matter), and have a slicer be able to default to that value based on that "Current (time period)" field. The user may want to select another non-default item from the slicer, but it should default to the specified value when opened/reset.

A filtered slicer doesn't help here, because it will limit the slicer selection to only the Current (time period).

The only workaround for now is to change the slicer value each day/week/month/year, save and republish. In a controlled production environment requiring a Change Request to promote production changes, this is not feasible for such small, regular changes.

Similarly this would help the default currency people, where there could be a different default for each region or even user, based on another column/measure/formula. Remember, we're just trying to make users' lives easier.

Thanks for all your hard work on this product. It IS appreciated.

Merged Idea (15)