How to Change table visual via a slicer

Power BI
2

@amruthdna2018,

Here’s one way to do this:

  1. create a disconnected supporting table containing your desired slicer values, in this case

Disconnected Employer Table = VALUES( Employee[Employer] )

  1. create a measure like this:

    Invert Slicer =

    IF(
    MAX( Employees[Employer]) IN ALLSELECTED( ‘Disconnected Employer List’[Employer] ),
    1,
    0
    )

In one copy of the visual, set your filter pane condition for that visual like this:

image
image282×598 9.6 KB

And for the other visual, set up the same way but with the value equal to 0

Now, whatever you select in the slicer, the second table will show the opposite results of the first.

image
image805×496 21.1 KB

I hope this is helpful. Full solution file posted below.