topic Re: Date Filter in DAX Commands and Tips

Date Filter

Anonymous — Wed, 09 Mar 2022 18:38:21 GMT

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!!

Re: Date Filter

Whitewater100 — Wed, 09 Mar 2022 21:26:07 GMT

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.

Re: Date Filter

Anonymous — Thu, 10 Mar 2022 02:19:56 GMT

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?

Re: Date Filter

Anonymous — Wed, 16 Mar 2022 07:54:54 GMT

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.