Set a dynamic default value for date filter

Question

Hi guys!&nbsp;I have a simple problem:I have a report with multiple filters, that filters a relatively big dataset. The underlying dataset is constantly refreshes (as more data goes into the underlying SQL table).&nbsp;One of the filters is a date filter, which determines a day - only data that have this date (in one of the columns in the SQL table) will be visualized in the report.How can I set the default value of this date filter to be always the biggest date? So if the consumer of the report opens the report he/she sees information of the newest day?&nbsp;It seems like an easy and simple task... but I cannot solve this.&nbsp;I already tried relative filter on the filter, but in this case the filter loses its feature - because it will only display the biggest date. Naturally I dont want that.&nbsp;Thanks in advance!

v-easonf-msft · Accepted Answer

Hi,&nbsp;Astorre72&nbsp;Current power bi doesn’t&nbsp; support you set up default value on slicer.However, here is a workaround you can take a try.You can create&nbsp; a new column (sort by date column) to replace the date fileld in slicer:&nbsp;&nbsp;SlicerDate = IF('Table'[Date]=TODAY(),"last date",'Table'[Date]&amp;"")&nbsp;&nbsp;&nbsp;sample pbix attachedFor more details,please&nbsp; refer to this post .&nbsp;BTY,you can vote&nbsp;below idea &nbsp;and add comments to&nbsp; to help improve slicer.Default Selected Slicer or Tile-By Value Configuration&nbsp;Best Regards,Community Support Team _ EasonIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.&nbsp;&nbsp;&nbsp;

Forum Discussion

Set a dynamic default value for date filter

2 Replies

Related content

Dynamic Filter

Dynamic Filtering

Dynamic default slicer

Dynamic measure filtering

dynamic x-axis based on filter