How to Limit Column Chart based on Date

[PatrickMcLeanGL]

I can set a data limit for my column chart to 25 columns, but then how do I specify to show the newest date and 25 data points before that? If I set the date field to top N = 25 and by "latest date" its not working (shows me dates in December).

[amitchandak · Accepted solution]

@PatrickMcLeanGL , Create a measure on date = Max(Date[Date]) , in Top of Date field use this measure and use top 25.

Means both Axis and Meausre are date in topn

[PatrickMcLeanGL]

Not quite sure I understand. What table am I making the measure in? Is this measure then used in the Filters on Visual? 

Edit: figured it out, ty