Forum Discussion
afaque03
Helper I
Helper IReverse slicer selection
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 2...
afaque03Helper I
Helper Ihi 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
Microsoft Employee
Microsoft EmployeeHi afaque03,
In try to reproduce this scenario locally, I’ll update here if I find some solution.
Best Regards,
Angelia