Forum Discussion
Filtering/Slicer Suggestion
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?
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
2 Replies
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