Dependent pair of slicers/ what if's

[singhal14]

Hello folks,

I am trying to create a pair of slicers which compliment each other i.e. if initially slicer A and slicer B has maximum and minimum ranges '0' and '100' respectively and we move slicer A to '10' then slicer B must not exceed 90 (its maximum range becomes 90) and vice-versa. I am trying to create what-if analysis from it so if it is possible from any other approach it would also be helpful.

Will be thankful for any suggestions or ideas. 

[v-shex-msft]

Hi @singhal14,

Since power bi not support to use measure as source of slicer and it not support to create dynamic calculated column based on slicer. I think it is impossible to achieve your requirement.

For your requirement, you can try to submit it to ideas forum.

Regards,

Xiaoxin Sheng