Forum Discussion

gumis_rulez's avatar
gumis_rulez
Icon for Helper I rankHelper I
2 years ago

Slicer affectin each other

Is it possible to build slicer which will be affecting each other?

 

I would like to build a forecasting tool:

- i want to have slicer for total yearly sales

- i want to have slicers for each month seperate

 

If i adjust yearly slicer by +1%, it should affect all month slicers and show +1% on each month;

alternatively if I change for january +3%, for february +2% and for march +10%, yearly slicer should change by percentage equal to yearly change (in this scenario lets assume by 2.5%)

 

Is it possible?

 

https://drive.google.com/file/d/1ksH7hxkxwOzZjqH72Kd8I05YUyKvW7MX/view?usp=sharing 

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    No, this is not possible as it would create a circular reference.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi gumis_rulez ,

     

    As lbendlin said, it's impossible.

    You can submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.