Display Matrix values based on Slicer Selected Item only

[BrianJ]

@yendluru.aj,

Please check out the solution I just posted below to a very similar question. I think the general approach laid out below should be fairly easily adaptable to your scenario:

How to Change table visual via a slicer

@amruthdna2018, Here’s one way to do this: create a disconnected supporting table containing your desired slicer values, in this case Disconnected Employer Table = VALUES( Employee[Employer] ) 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] And for the other visual, set up the same way but with t…

If you still have problems after trying this, please post a PBIX file along with a mockup of your desired outcome, and we can work through a more specific solution.

I hope this is helpful.

• Brian