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

3 Replies

  • Whitewater100's avatar
    Whitewater100
    Solution Sage
    4 years ago

    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'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.