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