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 Weeknum<=WEEKNUM(max(Sales_Date))
Explico , try a measure like
M1 =
var _max = Weeknum(maxX(allselected(Sales), sales[Sales_Date]))
return
calculate([measure], filter(Sales, Weeknum(Sales[Week]) <=_max))
1 Reply
Explico , try a measure like
M1 =
var _max = Weeknum(maxX(allselected(Sales), sales[Sales_Date]))
return
calculate([measure], filter(Sales, Weeknum(Sales[Week]) <=_max))