Forum Discussion
dynamic default value date slicer
Solution SageI am not sure if I understand your description of your model correctly or understand your issue fully, but I will try to provide som pointers.
You should always create a calendar table and link your fact table to this (remember to hide the data column in your fact - ultimate best practice is to have no visible columns in your fact and only have calculated measures showing)
In your data table you can create a column that dynamically will put your days into categories - e.g. past days, today and future days. With this you can then set a filter on your report to only show today and future days - this should make todays date the first date in your slicer - however you should note that the Power BI service will unless you deactivate this feature remember the users filters from the last time they had the report open, so if they yesterday had the report open and selected yesterdays date in the slicer this filter will still be active when they open the report again, so they may have to set the report back to default to have todays date as the first date in the slicer.
sdjensen, tnx for your input.
To clarify my issue:
The date column I use refreshes everyday and contains only current date (today) and dates in the future.
I use this date column in a dropdown date slicer and have added a relative date filter (next ...days(includes today) on the visual filter of the date slicer.
I want the date slicer to show and select the todays date / earliest date of the date column.
I then saving the desktop report and publish to the service and share with others through App.
My recruirement is that the date slicer dynamically changes/showing the current date when the report is refreshed every day, so the end-users should see the current day as default.
The problem now is that the end-users see the date from the day that the reports was saved and published to the service as default.