Dynamic titles with multiple slicers or filters in Power BI

We've talked about dynamic titles in Power BI before. But, what if you wanted to combine multiple values into that dynamic title. Patrick shows you how using a little DAX!


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #GuyInACube

[federicosantaanagreen]

These are great tips! Thanks a lot, Patrick, loved this one!
Similar to other viewers, it would be great if you can also explain this but with multiple selections in the filters. Thanks!

[ImranHussain-xvse]

Thanks a lot,
In one video, we got the idea about following

1 how to group measure in folder
2 use of selected value & combine values
3 use of variables

It means 3 extra stuff for learnings

[edgards]

Please make a video with multiple values selected?

[beckyshao]

Thank you so much Patrick for sharing these videos, that's exactly what happened to me quite often - when users come to me ask for something new, I'm like "Yes, I can do it", because Patrick has a video about it :)

[mytampham]

Hi Patrick, great video as always!
Can you provide the shortcut to translate the formula into dax format?
Thanks!

[catherinegould]

This is great! - I have been looking for something like this, now I just need to be able to apply it to a hierarchy filter. BOOM challenged!
One that would allow you to display the highest complete parent level with up to two deselected child slices/filters in the name ie "L1 Business (excl. L2 Name A and Name B)" more than two would be "L1 Custom Business" or the easy highest parent level (has all in its hierarchy lower hierarchies selected) "L1 Business"

[SolutionsAbroad]

Great use of selected/combine values function! I always used the simple & concat but your way looks more elegant!

[RossJams]

Patrick - your are a freakin rock star - every time i need something Power Bi you 'Guys in a Cube' are my first and last stop because no-one else is needed !! - thanks again!!

[Miloshlkl]

This channel is fantastic! I know most of the tricks that are showed here. I just watch because its sooo well explained!

[rynrbe]

Thank you so much for these videos, I am only just starting to get into Power BI and have been using mainly Excel in the past coupled with Access so this really is all very helpful to me.

[joelguay]

Hi Patric, what if you multi-select values in one of the filter ?

[rosinetempest]

Hi Patrick, I enjoy and learn a lot from your videos. Please can you do a video on how to create multiple slicers on the same page and how to make them interactive across all pages as well. Thanks a lot

[dariuszspiewak]

Hi Pat. How would you handle multi-selections where there are many items? For 2, 3 items you could use CONCATENATEX but what would you do if somebody selects, say, 20 categories (if there were that many, of course)? Thanks.

[kishore_p]

Thanks a ton Patrick! This feature is really useful! Your videos always help me to take my Reports to the next level!🔥

[fredjanssen]

Thanks for saving me a lot of frustration and time trying to figure this

[personalsigh]

This is great... I need to be able to add to the start of the title from different columns/measures created so in this example it is currently "2017 sales for..." but I need to be able to add in instead of just sales year or quarter or month etc so the end user can select either year, quarter or month and the it would be "Quarter 4 sales for" etc...

[ricardofarinha]

This is bananas 😂
Awesome work guys, super usefull tips. Keep the good work.

[pavoo]

Hey that's very cool, this is excactly that what I'm looking one little issue, whats happend when I choose 2015 + [CTRL] 2014.... thats not 'All years', thanks for advice

[tienngotk]

I am finding this way to make dynamic title, thanks for great method.

[Superok]

Great tip, will try it out tomorrow 😎thanks Patrick!