Forum Discussion
Create Slicer based on three columns condition
Anonymous
Anonymous 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.
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.
Anonymous
Anonymous 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.
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!!! :smileyhappy: