Creating a slicer that filters multiple columns in Power BI

Do you want to create a single slicer containing the values from different columns?

[maheshdama]

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

[amitshukla]

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

[karla_moran]

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!

[alexkim]

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

[forworkuseonly]

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

[pedropradocarvalho]

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

[tzeyongtee]

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

[vishaalpatel]

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

[davidtawa]

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

[poojasanathkumar]

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

[EricaDyson]

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

[ShivKumar-tziu]

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

[bhakthasingh]

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

[pravinupadhyay]

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

[maadala]

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

[ShabnamKhan-vkfj]

This is awesome, you guys are PowerBI hero!!

[Bharath_PBI]

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 👍

[marcossaraiva]

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

[suserman]

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

[DaylightLDN]

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