Filtering/Slicer Suggestion

Anonymous — Fri, 26 May 2023 03:34:20 GMT

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?

Re: Filtering/Slicer Suggestion

ThxAlot — Fri, 26 May 2023 04:56:52 GMT

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

Re: Filtering/Slicer Suggestion

Anonymous — Fri, 26 May 2023 06:12:37 GMT

Awesome! Thank you!

topic Re: Filtering/Slicer Suggestion in DAX Commands and Tips

Filtering/Slicer Suggestion

Re: Filtering/Slicer Suggestion

Re: Filtering/Slicer Suggestion