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 (524)
- Merged Idea (15)
RE: Default Selected Slicer or Tile-By Value Configuration
We have a scenario where we always view our data starting on the first day of the month. We would like a way to default the "From Date" to the "first day of the month" and the "To Date" to "today". This would allow our users to simply bypass this slicer when viewing the report, unless they want to tweak the range of dates they are reviewing.
RE: Default Selected Slicer or Tile-By Value Configuration
I have data for 7 years and average 200 rows per day.
When the Power View page is opened for the first time, the default value is selected – it should be today.
We need to choose one single date from calendar and filter data by this date.
Is it possible in Power BI Desktop?
RE: Default Selected Slicer or Tile-By Value Configuration
We have a KPI table that aggregates all data together. It makes no sense to aggregate the data like this so a default value is mandatory otherwise the users see nonsense numbers. They have to know to select which KPI they are after first.
RE: Default Selected Slicer or Tile-By Value Configuration
It was great if I can set current date/month as default selection in a slicer
RE: Default Selected Slicer or Tile-By Value Configuration
The issue is that the date slicer visual is stuck at the selection when PBI Desktop file is published to PBI Service.
For example if I have a date slicer selected at 4/1/2019 when my PBI file is published. I set the date slicer filter to relative date to show last 2 days including today. I also set the report on a daily refresh schedule.
On 4/3/2019 the refreshed report displays blank values because the date slicer selection is still stuck on 4/1/2019 when PBI Desktop was published.
The date slicer selection will only change if I republish PBI report with a new date selected on the PBI Desktop.
"Sticky Filters"and "Relative date" filter do not address this issue. I am looking for
an option to set the date slicer default value to a calculated measure in the visualization option so that when the report refreshes in PBI Service, the selected date slicer value is updated to the latest value from the measure.
RE: Default Selected Slicer or Tile-By Value Configuration
Please allow the default member to be defined by a DAX calculation.
For example: if today is monday than select last friday by defalt, else - select last date.
RE: Default Selected Slicer or Tile-By Value Configuration
Any update on this?
RE: Default Selected Slicer or Tile-By Value Configuration
One frustration I have is not being able to control the default for a relative date slicer. The main issue being Last Month. When selected it defaults to Last Month (Last 30 Days) but we need Last Month (Calendar). This catches out many users and reflects inaccurate data in reports. Meaning another counter-intuitive selection on the slicer to achieve the desired results.
RE: Default Selected Slicer or Tile-By Value Configuration
In our situation, we want to show a date range but have the begin date and end dates default to a value determined by a calculation (for example, first day and last day of a rolling 12 completed months).
RE: Default Selected Slicer or Tile-By Value Configuration
I have a slicer which I want to default to the user's name, with the slicer field being a list of other user's names, so it would be helpful if the slicer's default could be set via the value of a measure.