Forum Discussion
Dynamic time interval for one visual
I have multiple visuals on a page all being filtered by a Date[Year] slicer. I'd like to have one of the visuals show three years data which dynamically shifts based on the Year selected. For exa...
Hi KrisKolady ,
please share sample pbix file or data in excel
you can use below logic to restrict data for only 3 years by creating measure as shown below for that visual
calculate (measure,
filter(all(calendar[date]),
calendar[date]>=selected date- 3years &&
calendar[date]<=selected date)
)