PowerBI dashboard visual update when linked to time period filter (e.g year)

[tjems]

Hi, I have pinned a visual from a report that shows sales per month comparing this and last year. Currently the "Year" filter is explicit on "2017" and 2016".

My question is: When this year ends, I would like to the chart to automatically show "2018" vs "2017" without having to delete the dashboard visual and pin a new with this update. Even though this is not a big problem for just one dashboard visual, it becomes time consuming with increasing number of dashboards with the same visual (e.g. duplicate dashboards for Product A, Product B etc)

I have though about using a "IsInCurrentYear" and "IsInPreviousYear" calculated field to solve this. Any inputs on how to solve this?

Thanks! MA

[tjems]

Hi, I have pinned a visual from a report that shows sales per month comparing this and last year. Currently the "Year" filter is explicit on "2017" and 2016".

My question is: When this year ends, I would like to the chart to automatically show "2018" vs "2017" without having to delete the dashboard visual and pin a new with this update. Even though this is not a big problem for just one dashboard visual, it becomes time consuming with increasing number of dashboards with the same visual (e.g. duplicate dashboards for Product A, Product B etc)

I have though about using a "IsInCurrentYear" and "IsInPreviousYear" calculated field to solve this. Any inputs on how to solve this? 

Thanks!

MA

[Eric_Zhang]

@tjems

Try a measure

Measure = YEAR(TODAY())&" VS "&YEAR(TODAY())-1