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