Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multi Year Comparison - Same Tables, Change in Filter Year

I am creating a dashboard that compares the departments actual costs vs the plan for 2018. I have created a slicer for year that selects 2018

 

I want to create the same dashboard but with the dashboard having a slicer for the year that selects 2016. 

 

Essentially, I want to have one dashboard with the 2018 data, and the other dashboard with the 2016 data. 

 

I have tried using the Edit Interactions function to stop the 2016 Dashboard to only link with the 2016 year slicer. 

 

However I am running into issue where the Filter is picking up both years and the 2016 dashboard is picking up 2018 data. 

 

How can I resolve this?

Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    If you've already verified that the interactions are tunred off, is there a possibility, that one of the year filters is applied to the page level or all pages level?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    If you've already verified that the interactions are tunred off, is there a possibility, that one of the year filters is applied to the page level or all pages level?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      thanks Anonymous. I was able to figure out that one of my year filters was not turned off.