Problem with slicer and historical data

Question

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).&nbsp;&nbsp;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.&nbsp;&nbsp;So I get “sagsstatus” from the table “Sagsnavne” but it seems to ignore the &nbsp;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 · Answer

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

Forum Discussion

Related content

Visualizing Historical Data

Slicer visual problem

Problem with field parameter and empty slicer

Historical Log support

Exchange Rates - Historical