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 18 Oct 2024 21:14:06
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!
RE: Default Selected Slicer or Tile-By Value Configuration
I make a lot of reports that require the latest month to be selected where the relative slicer isn't appropriate. Just bumping this and adding to the comments
RE: Default Selected Slicer or Tile-By Value Configuration
Just get date slicers to automatically update to today's date, it's frustrating when a user opens a report after months away and they don't see up to date data by default.
RE: Default Selected Slicer or Tile-By Value Configuration
Yes- This feature will help when we have slicer of weekending dates and user want default current weekending date when he open the report. I have been looking for this feature everywhere to implement in my report and it is real requirement for ne now and I am new to Power BI. It is good to connect here and share our ideas.
RE: Default Selected Slicer or Tile-By Value Configuration
Especially for publish-to-web reports which are updated every day, it would be very helpful if the date slicer would dynamically include today.
RE: Default Selected Slicer or Tile-By Value Configuration
upvote
RE: Default Selected Slicer or Tile-By Value Configuration
it's been 84 years
RE: Default Selected Slicer or Tile-By Value Configuration
With the new "Clear Slicers" button, this is now needed for situations where some slicers should return to a default value instead of no selection. For example, where one of the slicers controls a field parameter where the typical case is a single value, but multiple select is still allowed.
RE: Default Selected Slicer or Tile-By Value Configuration
This is one of the most requested thing within my company. We should be able to give users the option to go straight to the latest months data. We don't want to use the relative date slicer as you can select a specific month and year from this. Its also impossible to create a bookmark that saves the view of the latest month as you would have to update it at the start of each month.
RE: Default Selected Slicer or Tile-By Value Configuration
Hello, just checking when the Power BI team might be able to launch this feature? Right now, users can't have the most relevant slicer option automatically selected for them, which makes all reports look out of date.Thanks,
RE: Default Selected Slicer or Tile-By Value Configuration
Hi, We have a requirement in many of our dashboards to open the report with latest month. In most of the reports we use Year/Month or combined field of Year-Month as a slicer so that the user can select a year/month to see the data. Most of ours are monthly selection and when the report is opened by someone it should always show the latest month as default. May be sort by the most recent or use a measure which has max date and set it as default value in a slicer. Ex slicer which is showing data in horizontal way 2022-10 2022-11 2022-12 2022-01 2022-02 If I open the report in Feb 2023, by default it should have 2022-02 as selected/highlighted