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 09 Feb 2018 03:54:31
We're looking into this request, thanks for everyone's votes and comments. 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 (386)
RE: Default Selected Slicer or Tile-By Value Configuration
Anyone from Microsoft can comment on the status?
RE: Default Selected Slicer or Tile-By Value Configuration
Can Power Bi give an update on the status of this? I need a report to default to current year and current pay period, out of a query that is generated every week. Right now the report consumers need to select the year and current period. The VP's want it to default to current on both hence the request. So right now for instance we would want year 2020, and period 22 selected in the slicer.
RE: Default Selected Slicer or Tile-By Value Configuration
I would really like to see the ability to use a start and end date slicer, but that can default to a preselected date range such as the current month to date. Many users would still like the ability to view any date range, even if the report opens with the current month. Right now, it's not possible to have it both ways.
RE: Default Selected Slicer or Tile-By Value Configuration
Has 3k votes and the last update on this is more than 2 years old! This feature is really needed, there is almost no project where this doesn't come up. This should work just like in SSRS, being able to set a default value for the slicer when the user opens the report (current year, current month, etc.).
And no, having another column in which I put "Current year" and use that as a slicer could be a workaround, but definitely nowhere near what the user wants to use, and let's be honest, it's not really a good solution on both ends: being the dev who needs to implement it or the user who need to understand why such a basic (reporting) functionality isn't implemented yet :(.
RE: Default Selected Slicer or Tile-By Value Configuration
Please add this, for PowerApps / Power BI tiles this is a must have for our users to have a context chosen by default based on user login.
RE: Default Selected Slicer or Tile-By Value Configuration
I have a Drop down list which contains multiple dates, This query refresh everyday and new date's data is being added on the list /table.
Whenever user opens the report latest date should be selected by default however user should have an option to choose other dates as well.
RE: Default Selected Slicer or Tile-By Value Configuration
Same as many others, I have a date dropdown list that contains all the dates when a data collection was done. I need my dashboard to always default displaying the most recent date in the dropdown list, but the older dates also need to still be selectable from the DDL. Sometimes the most recent date is today, sometimes it's last week, sometimes it's a month ago. I don't see any way to do that with relative date slicers.
RE: Default Selected Slicer or Tile-By Value Configuration
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.
RE: Default Selected Slicer or Tile-By Value Configuration
Relative slicer for 'last month' doesn't help. We need to have a dynamic default selection on a slicer with a list of months (same for years).
RE: Default Selected Slicer or Tile-By Value Configuration
would be nice to use drill through to an existing page with filters.
That the filter from the starting page is transferred to the secondpage.