Problem with slicer and historical data

[Epter]

I’m trying to build a report that show both current and historical economy. Everything works fine except I have a problem with the history. I cannot get the report to show the historical active projects in a correct way. On the screenshot below you can see the report and the filters, but sorry for the blurred numbers as its real figures. Everything is fine until I try to make a filter on the active projects (sagsstatus).

What I have done is I have 3 data sources that my reports are build on. On top of that I have 2 tables I use for the project names and periods. These tables I have bulid relationship between Sagsnavne (Project name) and the 3 data table and the link is the Project number. With the periods I have linked period and the 3 data tables.

So I get “sagsstatus” from the table “Sagsnavne” but it seems to ignore the  period that is build in to that table and show me wrong results. So I’m a bit stuck at this and hope that you can come with some inputs.

[lbendlin]

Usually you use a disconnected table to feed your slicer so that it is not impacted by filters in your data model.  In your case you'll need to separate the year from the day of year so you can compare like for like.