Forum Discussion
'Aligned Period' feature development.
Hello BI community, I am working on a dashboard and have been asked to make the Date and Country dimensions cross filter each-other. The feature has to be built in a way where if two countries are multi selected, the visual will only display up until the minimum date containing values. (In my screenshot where Belgium & Brazil are selected, I want the last month shown to be Feb 2023, instead of March 2023 because there is no value for Brazil). I am currently trying to figure out how to implement the second feature and have been finding it a bit of a challenge, any advice on how it can be achieved? Thank you in advance
Sample Data ModelVisuals UnfilteredVisuals Brazil & Belgium selected
2 Replies
Anonymous , Try a measure like
Measure =
var _max = Minx(summarize(allselected(Table), Table[Country], "_max", max(Date[Date]) ), [Date])
return
calculate([Measure], filter(Date, Date[Date] <= _max) )
