Forum Discussion

MathieuF's avatar
MathieuF
Icon for Helper III rankHelper III
1 year ago

Adapt according to the current date

Hello,
I have a date filter.
Is it possible for this filter to adapt according to the current date.
For example, I open my report, I want the end date to be the current date.
How do I do this?

I have a date table.
Thanks

6 Replies


  • - create a string representation of your date column, replace the latest date with a string "Latest"
    - sort that new column by the original date column
    - add a slicer or visual/page/report level filter
    - set the filter to "Latest"
    - publish the pbix to the workspace/app

  • Hello, I am looking at your proposals.
    I will test and get back to you.

  • Hello again Kedar_Pande , lbendlin ,

    I looked and I can't apply his method.
    My table is built like this:

    Calendar = ADDCOLUMNS(
    CALENDAR(EDATE(TODAY(), -36), TODAY()),
    "Datekey",ROUNDDOWN([Date],0),
    "Annee",YEAR([Date]),
    "Mois",MONTH([Date]),
    "Jour",DAY([Date]),
    )


    My "date" column starts from today to 10/02/2021.
    I use the following segment:

     

    I would like the end date to be systematically today's or yesterday's date.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User

      Use a dropdown slicer, not a "between" slicer.  Better - don't use a slicer at all. Use the Filter pane.

      • MathieuF's avatar
        MathieuF
        Icon for Helper III rankHelper III

        lbendlin 
        Can you show me an dropdown slicer segment?
        I still want users to be able to filter dates.