How to filter visual based on maximum weeknumber?

[Explico]

This is weekly sales chart for Y2022 and Y2029

I would like this chart to end at W16, but can't figure out ways how to do it 😞 any suggestions?

Would make sense to some Filter on visual where Weeknum<=WEEKNUM(max(Sales_Date))

[amitchandak · Accepted solution]

@Explico , try a measure like

M1 =
var _max = Weeknum(maxX(allselected(Sales), sales[Sales_Date]))
return
calculate([measure], filter(Sales, Weeknum(Sales[Week]) <=_max))