Forum Discussion

tjems's avatar
tjems
Regular Visitor
9 years ago

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

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

2 Replies

  • tjems's avatar
    tjems
    Regular Visitor
    9 years ago

    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