Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Date Filter

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...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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.