Creating a slicer that filters multiple columns in Power BI 

Through Your articles and videos I got the job in one of the best companies. Always waiting for your videos to make me as Powerful power bi Developer

What a great teacher you are..your videos are amazing! I've been learning Power BI recently and many times I get stuck. Watching your videos is helping me a lot. Thank you so much!

Alberto is my favourite. And his explanation is very simple and clear.

9:00 Table before adding key. 12:51 COMBINEVALUES Calculated Column. 13:42 Table after adding the combine CC to union. 15:15 Relationship

Definetly, I'm so proud to be student to SQLBI. Thanks Alberto!!!!

You just helped me solved my biggest headache of the week. Thank you so much for this, Alberto.

I really love data modeling, this video is golden, thanks for sharing!

This is great demo video, very easy to follow for novice power bi user!!!

Wow. you are a genius. This really helped me solve a problem in my work. Thank you! I shall most certainly be purchasing your books and courses in future!! Thank you again!!!

Than you so much!!! I love how you explain, so easy to understand!!

Great solution sir, salute your hard work, love from India

Thank you! This was a very special scenario to explain in depth, solved my requirement!

It's such a delight to learn from you.. every session is a true gem. Thank you so much.

Thank you so much, Alberto. You are the Master Manipulator of DAX.

Great video. Well explained!

Wow, you read my mind 🙂. Currently we're building the same, with one additional requirement. i.e., the visual should then get to the details page using drill through. I'm trying a work around for it using treatas, since I have slicer table as disconnected table. I believe if state and country were in different tables then also we can make this work. Thank you 👍

This is an amazing technique. Thanks a lot for making this video

That's great! ,I am using this kind of techniques of mapping tables to handle such granularity issues, That always works perfectly.

Thank you!! Very helpful!

This is very good

Which slicer is used in above visualisation for searching values

Hello Thanks for sharing the steps very clear, but I have one Month Slicer and date getting from A1 Column. I have another Slicer for Open Close Status, When I click on Open Slicer Month Slicer should take data from A1 column. When I click on Close Slicer Month Slicer should take data from A2 column Is this possible ?

Thanks for the video, How can you make a slicer to filter two columns in same table? Example: if I select "Red" it will filter the rows were Mother's favorite color Or Dad's Favorite color is red??

Magic it is! Thanx again Alberto

This is awesome, you guys are PowerBI hero!!

What a nice video. Which visual is it used to enter text ?

Alberto great work and insight! thank you for sharing with us

Hi Alberto, this is an awesome video that teaches a lot of nitty-gritty of how everything is interconnected in DAX. Can you please share your slicer settings? Are you using a custom slicer visual? I am only getting vertical lists, tiles and dropdowns, not labels with cross marks like yours nor can I type the names of places to add them to my slicer, like you are doing.

This is so awesome. Thank you for all your content!!

Thank you so much!

clarified clear) thank you! 👍

Really useful! In my case the second option takes less than the 50% of time.

Which slicer visual you used for this demo?

What visual were you using for the slicer? That doesn't look like the standard slicer.

what if we have multiple values, say "scenarios" column as values SC1; SC1; SC1 and Run "Column" has 1;2;3 , and then all other columns

Great video. I have an accounting report with dozens of attributes and measures and I want to let user filter the columns they need to see. Have you published a similar resource?

Grazie, Alberto!

please help i need to make an autoincrementing filter in power bi on a week basis

What if we want to do this columns comming from 2 different dimension table? Do we need to put the combined key column to fact table in that case?

Perfect

Thanks soo much... good solution...

Very usefull and well explained ! Thanks a lot for this time saver video !

Excellent very didactic class, Thanks Master

very useful...Thank you so much it helps lot!

Just for curiosity: Why do you prefer to filter the Customer table with your slicer table and not your fact (Sales) table, which would be closer to the star scheme? You could also add the CountyState key to the fact table, and the slicer and the graph in your report would show the same result.

Hi, it is good, but with out using bidirectional, we can implement this by using merge columns in power query. Kindly suggest my understanding is correct.

Hello, Thanks for this video. I have a scenario . Can you please help me on that. I have a table with 8 columns . I need to access the table by it's column name. So i need to add the column names as the slicer values. How am I supposed to do that?

Hi Mr. Ferrari, love your work. I have a question for you. Is it possible to create a model table from an existing Matrix Visual? The reason for asking is I am trying to create a dynamic column selection on a Matrix. To do that, I would need to have the table so I can unpivot some columns, then use a slicer to add / remove column on a newly built Matrix. Makes sense?

Dears I'm struggling with a similar situation. I have a fact table with several attributes, and for two of those, same values may apply. For example if one is salesman and another salesrep, but same person can be in both columns. How can I build a slices that at same time will show records where this name shows as salesman or salesrep. Many thanks in advanced.

Only four screens? ;)

Thanks for great tips !! Could you please also share how to create single slicer when there is a Date table is linking to both Customer and Sales and no relationship between Customer and Sales Table ? I am having this scenario and powerbi return circular dependency error with this method....

Is there a way to create a similar slicer where I can select multiple distinct values, for example, "United States" and "California", and return only rows that contain BOTH those 2 values? The way your model and slicer is set up right now will return all rows that contain EITHER value.

Very useful 🙏

Can someone please tell me which is the visual on the left whcih is being used as slicer?

This was a great video! I have followed your steps and everything is working perfectly! My categories are District, County and City. I had a formula to calculate the rank of each city included in a table regardless of the filters that were applied. Before I used the slicer Smart Filter Pro, I was using 3 separate slicers, one for District, one for County and one for City--with these slicers, the Rank formula was working correctly. However, once I used the Smart filter Pro slicer, the rank was ranking only the items in the table that had been selected. Do you have any ideas of how I can make the Rank formula ignore the slicer for Smart Filter Pro? Thank you in advance.

Please provide the data set for which these video's are done.

Which visualization do you use in this video?

My Visual Filters don't look like yours and I'm running June 2021.

Which filter visual are you using?

Ciao friend 😃😃😃😃