Forum Discussion

afaque03's avatar
afaque03
Icon for Helper I rankHelper I
9 years ago

Reverse 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...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
afaque03
Icon for Helper I rankHelper I
9 years ago

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's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi afaque03,

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

    Best Regards,
    Angelia