topic Re: How to get rows which is NOT selected in a visual in Custom Visuals Development Discussion

How to get rows which is NOT selected in a visual

Praj — Wed, 30 Nov 2022 17:33:23 GMT

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

Re: How to get rows which is NOT selected in a visual

Greg_Deckler — Wed, 30 Nov 2022 17:40:13 GMT

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

Re: How to get rows which is NOT selected in a visual

Praj — Thu, 01 Dec 2022 10:28:31 GMT

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

Re: How to get rows which is NOT selected in a visual

Praj — Thu, 01 Dec 2022 11:23:27 GMT

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

Cheers,

Praj