Forum Discussion
Solved
How to Limit Column Chart based on Date
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).
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
2 Replies
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
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
