Date Filter

[Anonymous]

Hi!

I am having trouble with making a date filter.

For this filter, I need to have the option that displays the date like the image below. 

I was able to make the feature so that the data will display the data for the current date. However, this filter is not filtering the data on the page.

I need the filter to filter all the data to only display results on the date selected and any subsquent data that falls on all the dates leading up to the selected date.

I was wondering if anyone had any suggestions.

Thank you!!

[Whitewater100]

Hi:

Can you use the time slicer with "Before" choice? This will bring in all data before this date. It can be page level filter too. Please ignore Cities in this image.

[Anonymous]

Hi, I need to incorporate something that will automatically have the max date set to the current date, do you know if there is any way I can do that with the time slicer before range?

[Anonymous]

Hi @Anonymous ,

Power BI won't reset the slicer selection automaticlly after each reopen or refresh.

I think you can create a DimDate table by calendar function.

Date = CALENDAR(MIN('Table'[Date]),TODAY()) 

Then relate DimDate[Date] with [Date] in your Fact Data table. 

You can use "Clear selections" in Slicer to make the max date set to the current date (today).

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.