Forum Discussion
RichFlorida
Helper V
Helper VDynamic 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 ...
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
RichFloridaHelper V
Helper VThank you jdbuchanan71
what is i'm interested in current Fiscal Year which starts in October 1st?
so, up tilll end of Sep it is one FY, starting Oct is is another..!