Forum Discussion

RichFlorida's avatar
RichFlorida
Icon for Helper V rankHelper V
4 years ago
Solved

Dynamic Date filter on a Chart

  Hello All,   I need to add a filter to my chart to make it display data for current_year only. I want this filter to be dynamic, this year will be 2022, but next year will automatically change ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  RichFlorida ,

    I created some data:

    2019 1.1 – 2023.12.31

    Here are the steps you can follow：

    1. Create measure.

    Flag =
IF(
    YEAR(MAX('Table'[Date]))=YEAR(TODAY()),1,0)

    2. Place [Flag]in Filters, set is=1, apply filter.

    3. Result:

    Only data for the current year will be displayed

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

Then you will proabaly have to add a column to your date table, something like FY offset that tags the current year as 0 and the previous year as -1 and the year before as -2, etc.  This would need to be dynamic so when it rolls to 2023, the year offset sets the correct dates as 0 to identify the current year.   Apply the year offset field as a filter on your report and set it to 0.