'Aligned Period' feature development.

[Anonymous]

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

[amitchandak]

@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) )

[Anonymous]

Hello Amit, Thank you for the reply. For some reason it doesnt want to accept that last 'Date' expression in the Minx function.  Is there something i am missing?