Filtering/Slicer Suggestion

[krixtsup3r]

Hi All, can I get some suggestion on how can I accomplish this. The scenario is that I have two columns in a table and I want to create a table visual that would create an inclusion or exclusion list. The sample data is user_id & project_id.

Creating inclusion list of users is easy as I you can use slicers and select the project_id but I am having a hard time to create an exclusion list of users, these are users that doesn't have a project id. Example scenario below and how the output should look like:

			Selected project_id		Selected project_id
			1		1
user_id	project_id		Inclusion List		Exclusion List
A1	1		A1		A3
A2	1		A2		A4
A1	2
A3	2
A1	3
A2	3
A4	4
A1	4

Do I need to create a DAX formula for this or is this something I need to do in Power Query?

[ThxAlot · Accepted solution]

Exclusion.pbix

First of all, PQ doesn't interact with viz canvas at all; any change on report / data / model view doesn't influence PQ.

As to your question, it's fairly easy

[krixtsup3r]

Awesome! Thank you!