Reverse slicer selection

[afaque03]

Hi Friends,

I have a year slicer in my report which has year like 2012 2013 2014. when I click on 2013 I want a visual of column of total amount for year 2013 and two diffrent line for 2012 and 2014 in the same visual. and when I click on 2012 then column should be of 2012 and line to be of 2013 and 2014 in the same visual. and same for the third case.

As in the above image if I select 2014 in slicer that column should be of 2014 and the two lines of year 2012 and 2013

[v-huizhn-msft]

Hi @afaque03,

In dataset, 2012, 2013 and 2014 year are same column, the value used to draw the line are same column, right? A slicer is used to filter the rows in table. When you select the 2012 year row, it will only return the result based on 2012 year rows, while we are not able to get reslut 2013 and 2014. Please review the similar thread.

Best Regards,
Angelia

[afaque03]

hi @v-huizhn-msft,

I totally got what u said, but can you help me to achieve this if we select year 2012 than the data should be of those which are unselected. Such that if I click on year slicer in 2012 I should get two line of year 2013 and 2014 and when I click on year 2013 than I should get two lines for year 2012 and 2014. So basically it should get the data of those two year which are unselected.

[v-huizhn-msft]

Hi @afaque03,

In try to reproduce this scenario locally, I’ll update here if I find some solution.

Best Regards,
Angelia