Create Slicer based on three columns condition

[Erica_Maidana]

Hi!!!! I am tryong to get a solution to the issue I have.

Based on the sample that I show above, what I want to create is a slicer that shows the following:

If I select Lost Partner in the silcer 1001 IT-Solutions GmbH should appear, but If I select in the slicer New Partner , this customer should appear too.

I tried to create a new column with an IF statement but this is going to show me only one of the value, Or it is lost or it is new, not both.

I added my solution here

https://www.dropbox.com/s/15m9ruvpo8c40x9/test3.pbix?dl=0

Please anyone could help here??? 

Thank you in advanced!!!

[Joorge_C]

I think you could do this in a matrix table that you can enter as data

CUSTOMER     TYPE

Customer 1     Lost Partner

Customer 2     Lost Partner

Customer 3     New Partner

then TYPE would be your slicer.

You could also try to replicate the above, if you duplicate this table multiple times in pquery and have a single partner type column in each, you could do a Repalace Values, where 1 will be "Lost Partner" in one table, and etc in other tables for the other Partner types. then change the Header on this value to the same Name  in all tables and Append all tables will give you a final table that can be used in a separate table related, where your one column would be your final slicer. 

[parry2k · Accepted solution]

@Erica_Maidana 

@Erica_Maidana solution attached. I added a new table in the model called "Partner Type" and added few measures. Table has one visual level filter to get this working. I hope this will get you going.

[Erica_Maidana]

Thank you so much @parry2k..It works as a charm!!! What I need to do now is to try to match some fields from my fact table to work with this new mapped table!!!