At first we compare weeknumber x 2016 with the same weeknumber 2015, therefore we created a parameter so the user can choose the weeknumber and get the KPIs for them.

Problem:

We want columns in the same dashboard where the user sees the KPIs for the year to week: Mindates are 01/01/2015 and 01/01/2016 and maxdates the last day of the week (the user chosen in parameter) 2016 and day 2015.

If you are filtering the view to just display Week 36 as a column, but still want to include data from other parts of the year, you can filter the view without filtering the underlying data so that you still have the underlying data for the KPI measure. Information about "filtering the view without filtering the underlying data" can be found here: