I'm new to PowerBi and I want to have the following:
I want to create a slicer which allows me to transfer 'capacity' from one entity to another. I.e. If the entity A has 300 capacity and entity B and C -20, I would like to create a slicer so I can transfer for example 20 capacity to entity B and 20 capacity to entity C.
I tried a what if parameter but without any success.
Thanks for the help! It is the expected final output in this case, but in other cases not.
I want to create a dashboard where my client can see his different entities with their capacity. Further, I want to provide a sort of slicer where he can interactively transfer excess capacity to another entity.
I.e. A has excess capacity of 300 and B is negative 100 so we take from entity A -100 and add to entity B +100. Entity C remains unchanged.
It could be that for another client entity C has 1000 capacity and entity A -200, so the same slicer which allows him to transfer -200 from C to add 200 to A.