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
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.
RE: Default Selected Slicer or Tile-By Value Configuration
This idea show's "under review" since Feb 8, 2018. Any closer to making this a reality?