Forum Discussion
anelliaf
6 years agoHelper II
Trailing 12-Month Visual
Hello, I have the following table showing the sum of costs for yyyy-mm: I'd like to display this in a basic bar chart, but dy...
- 6 years ago
I'm not sure if there's a way to dynamically alter the start/end points of a visual like that, but you could use some logic to get the same result with a filter - if you use the correct combination of dateadd/eomonth/today, you should be able to define each record as being in the previous twelve months or not, then use it as a visual level filter
edit - I've completely forgotten that there's relative date filtering as an out of the box option, try dropping your date field into that as a visual level filter and seeing if previous 12 calendar months will get you what you want?
amitchandak
6 years agoSuper User
Use a relative date filter or same option is also available visual level filter
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range