Skip to main content
Microsoft Idea

Power BI

Planned

Default Selected Slicer or Tile-By Value Configuration

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

Jim Richards on 06 Jul 2020 00:12:31

RE: Default Selected Slicer or Tile-By Value Configuration

for a date slicer: allow me to say tomorrow or today +3...

Jacek Power BI User's profile image Profile Picture

Bertrand Moser on 06 Jul 2020 00:12:21

RE: Default Selected Slicer or Tile-By Value Configuration

I have a hierarchical slicer that represents the company organisation. let's assume that this hierarchy is based on cost centers.
by default, this hierarchical slicer shall select the cost center of the connected user. but for benchmark analysis he ought select another cost center of the company.

Let me know if such expected behavior will be covered by this topic.

Jacek Power BI User's profile image Profile Picture

SudharshanKopperla on 06 Jul 2020 00:12:21

RE: Default Selected Slicer or Tile-By Value Configuration


our report has RLS, so for each user the default value of slicer should change.

Eg : If I have access to region A, B, C.. they want by default 'A' to be selected from dropdown when user opens a report.

If User 2 have access to region D, E, F.. they want default 'D' to be selected from dropdown when user opens the report.

and so on..

Jacek Power BI User's profile image Profile Picture

Mads Pedersen on 06 Jul 2020 00:12:20

RE: Default Selected Slicer or Tile-By Value Configuration

It would also be very useful if you could set a date offset.
For example, "-14" days. Then the slicer would always show the current date and 14 days back.

Jacek Power BI User's profile image Profile Picture

KumarBI on 06 Jul 2020 00:12:13

RE: Default Selected Slicer or Tile-By Value Configuration

Last response from Microsoft team is in 2018 Feb. is there any update on this.
we have quarterly reports, and refreshing manually on RS to show current/new quarter as default.

Jacek Power BI User's profile image Profile Picture

vikash vishwanathan on 06 Jul 2020 00:11:44

RE: Default Selected Slicer or Tile-By Value Configuration

My requirement is exactly below:

Please do consider implementing this. I have a single date filter slicer that I need it to default to the last available date. Not today, not yesterday, but the maximum available date on the dataset allowing the user to select other available dates on the report. Irrespective of the dates that I select, save and close my report, I want power BI to default to the latest date when I open the report after days or weeks.

Jacek Power BI User's profile image Profile Picture

Eduardo Conde on 06 Jul 2020 00:11:30

RE: Default Selected Slicer or Tile-By Value Configuration

Please do consider implementing this. I have a single date filter slicer that I need it to default to the last available date. Not today, not yesterday, but the maximum available date on the dataset allowing the user to select other available dates on the report.

Jacek Power BI User's profile image Profile Picture

Karl on 06 Jul 2020 00:11:26

RE: Default Selected Slicer or Tile-By Value Configuration

Right now we have to manually update our reports and republish just to get the default filters selected. This is functionality that is built into SSRS parameters that I would love to see added to Power BI slicers in some way (perhaps a measure or function to control the defaults, and allow both a begin/end date selection for dates). A common example is where the user wants to see a default date range selection for a transaction date (ex: beginning date: 3/1/2020, ending date: 3/31/2020) where the beginning date is the first day of the prior month and the ending date is the last day of the prior month. We could use relative date filtering but that isn't as intuitive to the end user, especially when they want to manually type in the begin/end dates if they need something other than the defaults. We'd like to reduce clicks and make this more intuitive, and the current functionality does not meet our end-user need. As such, we have additional manual work.

Jacek Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:22

RE: Default Selected Slicer or Tile-By Value Configuration

I NEED THIS !
I have multiple dropdowns that I need to manually change after the first dropdown was changed. Until it's not done, visuals are blanks. I've been looking for a workaround but couldn't find one so far.
Thanks in advance to implement this important missing feature.

Jacek Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:08

RE: Default Selected Slicer or Tile-By Value Configuration

I would like to be able to default a slicer to the current month range without setting it to relative date. That way when I need to see back a month or two AND ahead a month or two that I have that option. If I set to relative, I can only go back, current, OR forward.

Merged Idea (15)