DAX Dynamic filter, dates less than selected year

[giorgi_lommidd]

Hellow,
I have a table with two columns: [Date] (with hierarchy and date format) and [Cash Amount]. I have a line chart with Axis: [Date] and Values: [Cash Amount]. I also have Combo Box type slicer of Year (Date). I need to filter the chart with values less than selected year data from the combo box.

[Anonymous · Accepted solution]

@giorgi_lommidd ,

Refer below file

https://1drv.ms/u/s!Ah0UhoGdkH5biiABScUTFxwJZtOk?e=MCoXrV

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