How to Change table visual via a slicer

Power BI
1

Hi Team,

I have a slicer which has 4 values like New ,old ,expire etc.

and 2 table visulas to show detailed data

when i select New value in slicer the related data values must show in “table1 visual”
and remaining 3 values when i select it should show it in Table 2 visual.

How to achive this scenario in power bi.Kindly assist

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.

3

Hi @amruthdna2018, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!