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 (523)
- Merged Idea (15)
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.
RE: Default Selected Slicer or Tile-By Value Configuration
I have a date filter and new data is added in each day. I want the default date to move to the newest date automatically rather than having to do it manually as at present. I want the user to be able to filter by previous dates if they want, so can't use the relative date function.
RE: Default Selected Slicer or Tile-By Value Configuration
I have seen a lot of posts that mention how we can use ISFILTERED and ALLSELECTED functions to create default behavior on Charts. From a User Experience, these default selections need to be shown as selected in the slicers so users understand they are not seeing all records but specific records.
RE: Default Selected Slicer or Tile-By Value Configuration
Sticky filter is not the same.
Because thats for the current user. We want to have a slicer to be able to dynamic select current year as default. So each user that opens the report in Power BI service will have last year selected..
RE: Default Selected Slicer or Tile-By Value Configuration
for a date slicer: allow me to say tomorrow or today +3...