How to get rows which is NOT selected in a visual

[Praj]

Hello Everyone,

I am loooking for a way to gather rows which is not selected in a visual. 

For example, 

Below is my dataset which has two columns-User and Event Attended.

I am using a date slicer on column "Event Attended".

I know whenever I select Q1 in my slicer, the users who are associated with an event during that quarter is displayed in the table like below image however, I am looking for a way to display the users who are not part of Q1. Is there any way to get these user details(cc,ee,ff).

Any approach for this problem is appreciated. 

Thanks in advance

Cheers,

Praj

[Greg_Deckler · Accepted solution]

@Praj Try this inverse slicer method: Inverse Selector - Microsoft Power BI Community

[Praj]

Hi @Greg_Deckler ,

Thanks for your approach. The standard selector is woring in my case however, the inverse selector seems to be blank and doesn't show any data. I am using DATE as a slicer.  Below is the code I have modified for my case 

Standard Selector = 
VAR __dept = MAX([User])
VAR __products = VALUES('Date'[Event Attended])
VAR __table = SELECTCOLUMNS(FILTER(ALL('Engagement'),[Event Attended] IN __products),"__dept",[User])
RETURN
IF(__dept IN __table,1,BLANK())

Inverse Selector = 
VAR __dept = MAX(Engagement[User])
VAR __products = VALUES('Date'[Event Attended])
VAR __table = SELECTCOLUMNS(FILTER(ALL('Engagement'),[Event Attended] IN __products),"__dept",[User])
RETURN
IF(__dept IN __table,BLANK(),1)

Below is the visuals

I am not sure if this is because I am using date as a slicer.

Cheers,
Praj

[Praj]

Nevermind @Greg_Deckler, The solution worked! I made a small mistake in slicer.

Cheers,

Praj