Forum Discussion
Solved
Dynamic Years
Hello Experts, I would need your support in a report that has a special requirement on showing years dynamically. Description of Requirement: In the charts of the reports, there should ALWAYS b...
You could create a couple of measure like
5 Years Visible = VAR CurrentYear = MAX ( 'Date'[Year] ) VAR ChosenYear = [Previous version] VAR Result = IF ( CurrentYear >= ChosenYear && CurrentYear <= ChosenYear + 5, 1 ) RETURN Resultwhere [Previous Version] is a measure which returns the desired start year according to your logic.
Apply this measure as a filter on the visuals set to show only when the value is 1.
Hi Johann_32,
You would need a disconnected calendar table or at least a table with years to achieve that. You can check the solution for previous N periods in the video below and modify the logic to future years:
https://youtu.be/d8Rm7dwM6gc?si=cebTXDnQP9pWTIpB