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 (531)
- Merged Idea (15)
RE: Default Selected Slicer or Tile-By Value Configuration
Please let Microsoft know, this is one of or the very top feature requested by Power BI users!
RE: Default Selected Slicer or Tile-By Value Configuration
I have a dashboard which is comparing the last two month's data. Currently, this works by having exactly two months loaded in.I have a replacement prepared which can also show historical data. However, this breaks the user workflow because it cannot automatically show the current situation. Instead, this must be selected manually. Being able to set the slicer to MAX (via measure or otherwise) when the user has not chosen an earlier value is essential to allow the old dashboard to be removed and users redirected to the new solution. In my case, this is not aligned to months and therefore uses a serial (e.g. R05, R06...) instead of a date field. It is therefore important that default values are available to all field types and not just dates.
RE: Default Selected Slicer or Tile-By Value Configuration
Dear Microsoft team, what is the actual status on this issue.Thank you for your answear!Best regardsIrina
RE: Default Selected Slicer or Tile-By Value Configuration
Please make an update to the current state! The Relativ Date Slicer is not helpfull at all. Everytime a new month has started, it needs to change the current month to the actual month - not the workaround with "current month" as the name.Thank you.
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
Before I start this rant, I want you to know that I am a big fan of Power BI and its undisputed number one position for dashboarding/reporting solutions. The rate of change since the early inception days and Microsoft's commitment to providing a world class product is commendable. But then there is this ongoing issue of there not being an acceptable solution to have a default value for slicers. As others have posted, there are a number of workarounds, none of them, in my opinion hit the mark. I have used Microsoft's other reporting product, Reporting Services quite extensively, even before Power BI was around, and their ability to have a default value for a parameter based on a hard coded value or a value derived from a query is a simple, yet powerful solution. I cannot understand why Power BI does not have the same type of functionality, especially as both products are Microsoft.From a user perspective, they want to see current relevant data when they go into a dashboard without having to scroll through a list to find the latest month or have "Current Year" or "Current Month" as options. Sticky filters or Relative time filtering are also not really suitable especially if you want to see the latest month for which you have data. We might be in calendar month of today but the data in the dashboard might only become available during the course of the current month. Sod until that becomes available the slicer must default to the latest month, we have data for, i.e. last month, which changes to this month once that data is loaded later in the month.I also know there might be 3rd party visuals available which might address this issue, but surely, this is a big enough requirement and has been requested by many community members that justify that this be rolled out in the base Power BI offering.Pretty please.......
RE: Default Selected Slicer or Tile-By Value Configuration
Any updates to share? Administrator message dated May 20, 2024 stated rummy
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.