Skip to main content

Power BI

Planned

Default Selected Slicer or Tile-By Value Configuration

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

sunil.tak@bizmetric.com on 06 Jul 2020 00:01:58

RE: Default Selected Slicer or Tile-By Value Configuration

Not sure, if i am writing this at correct place. If no, i am sorry but i don't know where to raise it.

I have below user's data. I have setup RLS
User Product
User1 Product 1
User1 Product 2
User1 Product 3
User2 Product 4
User2 Product 5
User2 Product 6

I want, "Product 1" should be default selection when User1 logged in and "Product 4" default selection for when User2 logged in. In other words, first valid value per user should be selected. Can we do this in Power BI? Please let me know.

Jacek Power BI User's profile image Profile Picture

Robin Gold on 06 Jul 2020 00:01:38

RE: Default Selected Slicer or Tile-By Value Configuration

I, too, need the ability to have date slicers in my reports default to the latest/max date (which is not necessarily today or yesterday).

Jacek Power BI User's profile image Profile Picture

Russ S. on 06 Jul 2020 00:01:35

RE: Default Selected Slicer or Tile-By Value Configuration

We really need this, in a drop down list, I want to latest date to be selected,k after a refresh latest date selected, and when subscriptions go out, it should have this date.

Jacek Power BI User's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:01:22

RE: Default Selected Slicer or Tile-By Value Configuration

We are still waiting for that ability !! We really need it

Jacek Power BI User's profile image Profile Picture

Subhrajit Ghosh on 06 Jul 2020 00:01:21

RE: Default Selected Slicer or Tile-By Value Configuration

For example, in a date slicer by default StartDate and EndDate should be Today after each daily scheduled refresh.
This is a critical requirement.

Jacek Power BI User's profile image Profile Picture

Alexander Bromberg on 06 Jul 2020 00:00:53

RE: Default Selected Slicer or Tile-By Value Configuration

We also require this feature for a lot of customer cases!

For example, we want to compare today's with yesterday's performance but the user should still be able to change the slicer date. Therefore a solution is highly appreciated without fixing the date manually.

Jacek Power BI User's profile image Profile Picture

A Power BI User on 05 Jul 2020 23:59:57

RE: Default Selected Slicer or Tile-By Value Configuration

This is also a serious deficiency in being able to use RLS effectively. Right now a slicer will attempt to use a default value that has been filtered out by RLS (and thusly load no data into the report by default). That's ridiculous. Either Slicers need to correctly default to values they can actually utilize, or this could be implemented so that you could setup a DAX Measure that feeds a default slicer value based on what is available in RLS. There's a bunch of inelegant hacks around this right now that I would rather not implement.

Jacek Power BI User's profile image Profile Picture

Nikhil M on 05 Jul 2020 23:59:41

RE: Default Selected Slicer or Tile-By Value Configuration

When our client opens the report after an overnight refresh, s/he would definitely like to see today's data as soon as the report is opened. Not yesterday's. Unfortunately, the slicer cannot be set to a default value of TODAY () and therefore this is a very important feature and I am surprised when its missing, after all these years.

Jacek Power BI User's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:59:33

RE: Default Selected Slicer or Tile-By Value Configuration

I would find it very useful in a number of reports to be able to have a default value in a date slicer set to be today's date.

Jacek Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:59:15

RE: Default Selected Slicer or Tile-By Value Configuration

I need the ability to set a default relative date (e.g. the last 30days) but have the slicer sent to between. The relative date slicer does not work for many reports.

Merged Idea (15)