Slicer for different columns on different tables

[ABR002]

I need to create a way to slice pursuits my company has done based on if they are completed, cancelled, or in progress. The problem is that the criteria for completed and cancelled is on one table, and the criteria for in progress is on another, and uses a completely different criteria. They have a relationship via the customer # Column.
Complete/Cancel Table example:

Customer #	Group
555	Complete
999	Complete
6543	Cancelled
444	Cancelled
324	Complete
456	Cancelled

In Progress table example, in progress is designated as being in the future, for now I have a calculated column (After Date) that gives a 1 for in the future (meaning in progress) and a 0 for in the past (completed or cancelled:)

Customer #	Completed Date	After Date
111	12/31/2021	1
324	1/3/2020	0
333	7/20/2021	1
444	4/28/2020	0

I need to be able to slice the customers based off of the pursuit status, slicer choices example:

Completed

Cancelled

In Progress

Thanks for any advice!

[Ashish_Mathur · Accepted solution]

Hi,

In the In Progress Table, create another column called Group (same spelling as in the first table).  Then append the 2 tables.  Now use the Group column for slicing.

[Nathaniel_C]

Hi @ABR002 , not sure if I understand what you are trying to do, but if the two tables are related by one column, then you could merge the two tables in Power Query, and then you could pull the slicers out of the one combined table.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel