Forum Discussion
Solved
How to filter visual based on maximum weeknumber?
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 Week...
Explico , try a measure like
M1 =
var _max = Weeknum(maxX(allselected(Sales), sales[Sales_Date]))
return
calculate([measure], filter(Sales, Weeknum(Sales[Week]) <=_max))
Explico , try a measure like
M1 =
var _max = Weeknum(maxX(allselected(Sales), sales[Sales_Date]))
return
calculate([measure], filter(Sales, Weeknum(Sales[Week]) <=_max))