Bar chart - Custom Dimension

[Karthick30]

I am using bar chart in my App. Used all saturday's date as Dimension. 

But I have a requirement now. I want to stop this bar chart exactly at year end(12/31/2021).

Below screenshot shows after 12/25/2021 , it moved to 1/1/2022 as per saturday date. but that particular week alone I need to stop at 12/31/2021(i.e friday)

Same way in upcoming years too.. chart has to grow for every saturday and stops exactly at 12/31/20XX(irrespective of day)

Any way to achieve this

[rubenmarin]

Hi you can add set analysis to expression to filter data, ie:

Sum({<SalesDate={"<=$(=Date(YearEnd(Min(SalesDate))))"}>} Sales)

Or: Sum({<SalesDate={"<=$(=Date(YearEnd(Today(),-1)))"}>} Sales)