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
To Power BI users everywhere: Please let Microsoft know the product is not really functional without slicers that can be preselected intelligently. For example, there is no way to preselect the most recent month (in a way that allows other date ranges to be selected). Yes there are ridiculous workarounds that take huge amounts of effort and don't really work.
RE: Default Selected Slicer or Tile-By Value Configuration
The sticky filter is not enough.You need to make it possible for the business owner to direct what the report audience shall see when opening the report and/or resetting the report filters in order to focus on the desired "time window" etc.In addition to making it possible to set default values, make it possible to set a new option "mark as date slicer" on/off, and thus enable the Date Filtering options in the slicer visualization.One angle is simply put to move the existing filter pane options to the Slicer Visualization Options.So, add the options:Set as default value (when opening/resetting/refreshing)Mark as date slicer
RE: Default Selected Slicer or Tile-By Value Configuration
To Power BI users everywhere: Please let Microsoft know the product is not really functional without slicers that can be preselected intelligently. For example, there is no way to preselect the most recent month (in a way that allows other date ranges to be selected). Yes there are ridiculous workarounds that take huge amounts of effort and don't really work.
RE: Default Selected Slicer or Tile-By Value Configuration
To Power BI users everywhere: Please let Microsoft know the product is not really functional without slicers that can be preselected intelligently. For example, there is no way to preselect the most recent month (in a way that allows other date ranges to be selected). Yes there are ridiculous workarounds that take huge amounts of effort and don't really work.
RE: Default Selected Slicer or Tile-By Value Configuration
I also request a new request as belowhttps://ideas.fabric.microsoft.com/ideas/idea/?ideaid=e20cfedc-1973-ee11-a81c-000d3adc66b1
RE: Default Selected Slicer or Tile-By Value Configuration
From our business we had also received a similar requirement to have "Default Year" selection to a Slicer. We have done a workaround for this by ourselves.Using Relative Year, we had flagged. Current Year as 0 and called it into Year1 column as "Default Year", e.g. 2023 is shown as "Default Year" and rest year as it is.Using Custom Hierarchy, we had created a Time Period Hierarchy and in Report have used it in a report slicer and selected. "Default Year" option.Since Hierarchy was there, we did not get any problem on computing YoY calculations.
RE: Default Selected Slicer or Tile-By Value Configuration
This has been on the wish list for most of the past decade. My team is really suffering from not having a functional date slicer and slicer pre-selection feature in general. On behalf of all Power BI users, please make sure this is in your next release. Best regards,
RE: Default Selected Slicer or Tile-By Value Configuration
Is there any update that can be shared? The Oct 20, 2022 Administrator message said it would be worked on the coming year (2023).
RE: Default Selected Slicer or Tile-By Value Configuration
Please ensure this functionality allows a fully dynamic start/end date selection.For example, in my organisation we have reports that want default dates to be:last complete Mon - Sun weeklast complete Sat - Fri weeklast complete monthyear to yesterday (01/04 start)year to last month end (01/04 start)rolling 28 days to yesterdaybut (crucially) still allow uses to select any date range outside of these (and still limited by the dates in the data).This issue is our single biggest frustration with Power BI. We could do this 15 years ago in Oracle BI by setting the start date and end date to parameters (usually populated from a database query).
RE: Default Selected Slicer or Tile-By Value Configuration
I believe if you look through all the comments, including ones that have not been merged to this thread, this would become the single most consistently requested feature. In all reports today, the slicers are out of date because there is no way to dynamically update them.