Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Erica_Maidana
Helper I
Helper I

Create Slicer based on three columns condition

sample PBI.PNG

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!!!

1 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.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

3 REPLIES 3
Joorge_C
Resolver II
Resolver II

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. 

@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.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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!!! Smiley Happy

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.