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!
Download Sample: guyinacu.be/dynamictitlesample
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #GuyInACube

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

[@ImranHussain-xv4se]

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

[@federicosantaanagreen6143]

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!

[@edgards]

Please make a video with multiple values selected?

[@beckyshao1729]

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 :)

[@GuyInACube]

hahaha love it! 👊

[@rynrbe3066]

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.

[@gauthamk1485]

Hey Patric, I like the way you come with an example usually what we face in our regular work :) and...... as you said, I know Patric always has a video particular to the topic which I'm looking for.

[@kishore_p93]

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

[@diannedrechsler4792]

This is great Patrick, thanks so much! I'm new to Power BI and still have my L plates on and this was super helpful.

[@SolutionsAbroad]

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

[@cleanthisconstantinou7013]

Patrick...you are a life saver! Kudos to you and the team!

[@angelfish423]

Thanks for this solution! This has solved a dynamic title that I have been trying to add to a new report that I am just creating, so thank you!

[@joedickson1]

Thanks for your video! I'm using a combination of your suggested SELECTEDVALUES with Dynamic Values in Text boxes!

[@catherinegould6662]

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"

[@JamesMedaugh]

I love this. I'm putting this in practice this week. Great work!

[@rosinetempest2133]

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

[@antoniojosemoraesdoprado2042]

Hi Patrick, great video. It is exactly what I was looking for. Thanks for your help. Congratulations

[@ricardofarinha1700]

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

[@Super123ok]

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

[@hanguyenthai8979]

Great video Patric!!!, that's exactly what I need right now, thanks a lot!

[@mytampham]

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

[@mariocamara4855]

This is awesome, keep up the great work, love you video's - i have learned so much watching your videos. Thanks so much!

[@tienngotk]

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

[@jamespratt1656]

Thanks for this Patrick - really helpful for me as I transition to Power BI from Tableau!!

[@Milosh00lkl]

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

[@abhayverma2585]

Hi, Can you tell the measure definition if multiple values are being chosen?

[@Milosh00lkl]

abhay verma i just count them and display “multiple selection” if selection count is > 1 if that is what you are asking

[@claudinesimon-cederroth1766]

Fantastic video! thanks so much for being so thoughtful and thorough!

[@Hamid-tb8kc]

Patrik, you are always making me "WOW", LOVE your videos guys.XOXO

[@alt-enter237]

As always, just what I needed when I needed! WHAT THE FRENCH TOAST??!?!! You are the best Patrick.

[@Smitty998]

This is an awesome. This video saved me sooooo much time. Thank you for posting it!!!!

[@ildashabani2358]

Thank you for sharing all your tips and tricks 😅 Very useful and helpful

[@saisatya5525]

Hi Patric, great learning as always.

[@dariuszspiewak5624]

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.

[@totemimaging]

Great content and love your enthusiasm - major help, thanks!

[@Sophie-uv4dp]

Hey Patrick. Thank you for sharing this, very helpful. How about dynamically showing the "Top N" selected values from a filter panel in the viz title? Following your guide here, it is not able to pick up the Top 10 or Top 20 or whatever number I chose on that particular viz. Thoughts?

[@crisgath3512]

Alway a fountain of DAX knowledge. Thanks Patrick

[@piraviperumal2544]

Love your videos and the vibe you create :)

[@martricegilkey6352]

Thanks Patrick this is really helpful!!!

[@dylansherman5957]

Hi Patric , Love all your videos you have taught me so much. Is it possible to to get a count of values based on a dynamic measure ? I have a percentile measure that varies depending on the slicers. So this tells me the cut of point. I would like to know a count of people that fall into that percentile ? Thanks

[@fran6049]

Hi, How do you build that column chart with the line series being horizontal through the whole category and vertical between categories

[@ShabnamKhan-vk7fj]

This is amazing, thank you Patric!

[@RobinPandita]

Thank you PaTrick for explaining this trick. I have learnt a lot by watching your videos. Can you help me with the below scenario? If we have three filters Filter 1,Filter2 and Filter 3 and whenever we select a value in Filter 1,the related values change in other filters as well and then if you select a Filter 2 and again click on Filter 1,the previous value in Filter 2 retains and doesn't change unless we clear it by clicking on small reset button on top of the filter. Can you please make a video on this?

[@gabrielsamayoa4981]

Thanks a lot Patrick it really helps a lot all your content

[@Cobalt58_9]

It makes me feel a little better I'm not the only one asked to spell out even the most obvious reports.

[@sobhagyashri]

Hi Patrik Thankyou so much for this video. It was great to watch it. Is there a way where we can select one slicer for two categories. In one I want to see the customer meeting held in one month in the next graph i want to see the pipeline of the rest of the months in the same year.

[@fredjanssen1207]

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

[@GuyInACube]

Most welcome Fred! 👊

[@olunugaoladipupo7058]

Great stuff, amazing techniques. What if I want to select more than one option per slicer, for instance, I want to select 2015 and 2016 or accessories and bikes?. How can i show both selected option on my title.

[@romustdie]

Awesome information, thanks!

[@odianosenakhibi5144]

Thank you for this video, what if we want to apply the same logic using a country slicer but show different titles/text if different countries are selected?

[@js3883]

This is good for me being a new Power BI user.

[@bubblegum459]

You are a treasure Patrick ! Thanks a lot !

[@1rebel315]

Dude you rock! live from Redstick, LA

[@jlmacalisang]

Hey Patrick, Can we dynamically change the report titles based on the charts/objects that are shown in the report? like the first button, when you pressed it, it will show the reports summary by world area, then if the second button pressed, the report summary by category will be shown and so on. Is it possible instead of using the filters as a basis? Thanks man!

[@aravindl3540]

Hi Patrick, Can you explain how to pull values from different columns in a second table based on the values from a column in the first table.. Thank u for ur work.. it really helps.

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

[@Scooterboy_and_others109]

Same here. Curious to know if its even possible

[@KathyGi]

what if I want to display the previous year on a card with the title "Sales for 2018" if I selected 2019 from the year slicer? how do i get to change the header to calculate "-1"?

[@kunalpratap7375]

Thank you Patrik for this video. I have some issues while doing it from filter pane. Can you please explain that as well. Thanks in advance. :)

[@Vykhari1]

Thank you so much Patrick!!

[@shoeb1359]

Thanks a lot Patrick !!! I have one question regarding Star rating . There is not a custom visual where we can represent Ratings per categories. I did it through unichar code but it's not work when we have rating in decimal .How we can show half filled in star in case of 2.5 value. Please suggest some idea Thanks in advance

[@benzerbib8965]

Hey Patrick! Thanks a lot for all your work on these videos! Helps me a lot! I have a question that you could use for your next video: I have a table with a Price column and a Currency column. The Total column is calculated based on the Price column but it is not taking into account the Currency of the Price. Example: the first line on Price is 15$ and the second line s 12Euros, the Total will display 27 but it is not true! How to solve it please! Love you guys!

[@buttshooter1]

Hi Patrick, how did you do the auto DAX formatting on the fly?

[@pavoo8960]

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

[@michaels1813]

Hello, How did you get the layout look with the drop shadows?

[@THEXExperiments]

2018 Sales For Bikes and Clothing in Canada and Australia How we can set in this format like Selecting Two or more in One Slicer?

[@contactvenkat]

Hi Patrick, Can you please explain how to create a dynamic title for the tooltip. I have one tooltip and a report with 4 visuals. When I hover over the visuals the title should change dynamically. Is it possible in power bi?

[@user-wn6sj1pl9y]

Thanks for video, have a question. How to make it more flexible? if have about 10 attributes only about goods, do you have an idea, how not to wright 10 conditions?

[@lyndsey-cp5yn]

Hello, this is a fantastic video thank you ;o) I have managed to set this up with my slicers, but i also have 'buttons' on my dashboard, linked with bookmarks, can i add the bookmarks to this Dynamic title? If so how and could you advise me please, thank you

[@jaywills5776]

Awesome. But what if you have months under years (in the same slicer) now you can select a year (and the slicer will select all its months, even if you chose single select mode!) OR a single month. So what DAX can deal with that?

[@jlmacalisang]

What a great video!! nice one bro!

[@taraosborn2696]

Is there a way to make the dynamic title I created (THANKS BY THE WAY) to work on different pages? For example I have the same title at the top of 5 different pages. I would like for when the title is changed on the 1st page, it also gets changed on the other 4.

[@stephencross4978]

you rock Patrick, thanks for great info !!!

[@joedoe2129]

This really bananas Tks Patrick!

[@pabeader1941]

Patrick, at 11:24, when you are selecting in the filter, I notice that there is a blank option. What caused that and can you fix it?

[@TonyRhoades]

Hi Patric, I have searched high and low for how to create "Dynamic Titles" for "Filters on this visual" when multiple filters are applied. I didn't find this in your videos. Do you have anything you could share? Thanks

[@nareshd4199]

Please help me I want to show parameter like text box in report how to do this, we have an option in tableau we can show it as filter in tableau but not in power bi

[@nikitashevchenko8525]

Hi man! I have a pain about renaming measures in the tabular section, what do you think about that ?

[@zhenxiang2821]

Hello Patrick, i tried with your method, however, this only works when you make filter under page level. how about make filter under visual level?

[@udaymishra865]

Hey Patric, How can I have Year to date filter if I don't have date in my data, what I have is Period1, period2 through Period 12

[@catherinevaldez2360]

Hi Patrick, how does dynamic title work for relative dates?

[@vinodkumaryalamanchili1831]

Can u able to help me to get, How to pass report from other report by using selected measure in Power BI

[@Ai.music.is.everything]

Hi 😊 , can we make the dimension to change automatically to a lower level when a slicer or filter is set . Without using field parameters to change the dimension. Example, in a pie chart, it is set to Category dimension, when they change slicer to a specific category, then the pie chart should be at sub category level. Similarly that can go to multiple dimension levels - products, customers and so on. Thanks 😊

[@MUGDHA251]

hi Patrick Can you guide how to make this kind of combo chart where line is in a structured way

[@anonyingyongyut4326]

Hi Patrick .How do you formatting code ? what's shortcut ?

[@ruturajdeorukhkar8006]

Great stuff ! Can we do the same with a between slicer ? I have been trying to do that and could not get passed selecting the first value of the range 😅

[@NorbertL85]

Amazing Video, Multi Selection would be awesome too. Thanks a lot for your outstanding Videos - my first source for Power BI

[@GuyInACube]

Multi selection could be done with some extra DAX. We specifically didn't cover that in this video though.

[@christopherwebb1237]

This blog post covers dynamic chart titles with multi-select blog.crossjoin.co.uk/2016/04/25/dynamic-chart-titles-in-power-bi/

[@TonyLinsenbreit]

Hey Patrick, I am currently building a dashboard in Power BI. I want to display the scrap rates in a Chart. However, depending in the selected Location (X, Y, Z), the two choices/Filter Options (for Location X - assembly, Location Y - Automotive, Location Z - assembly), Multiple values are selected. How can I display the title of the diagram depending on the actually activated value (assembly or Automotive)?

[@maverick173]

LOVE IT! Thank you.

[@jenyura]

If you have several categories chosen, can you indicate all choices?

[@robinneven1237]

Hi Patrick, great stuff! What's the difference between COMBINEVALUES and CONCATENATE(X) here?

[@amirhd2080]

New trick again. Tq mas bro

[@amymouskountakis1162]

Hi Patric. What if you have selected multiple values but you only want a title to contain the largest value? My example, is that I am working with hours. If I need 72 hours, I have to select 24, 48 and 72 but I only want the report title to show 72 hours, Is there any way to do this? Thanks in advance, Amy

[@chandrapamidikalva3277]

Hi Patric, Can you please create a video on what are the resposibilities of a power BI Architect

[@TracyVonFeldt-br9br]

Your dynamic titles video with multiple filters selected was super helpful, thank you! But, what if multiple values are selected under one filter? I work in healthcare and users of my report may want to look at multiple facilities at one time, but the dynamic title stays on “All facilities” if I select more than one facility. Is there a way to write the DAX so it will update to show all selections under the same filter? Also, in this video you changed your measure to DAX formatting really quick…how did you do that? I’m a newby to Power BI. 😁 Thank you!!!

[@babybru3154]

How to do this when using analysis server tabular mode?

[@sixtyfiveroses2968]

Great Video

[@Tanya-og7no]

Hi can we also do another change in this and show all the selected filters in title? If someone wants to see two years and selects 2 years then can we have the title reflect that "2019, 2020 Sales for"

[@lokesh2635]

Does it works for multiple selection on slicers ???

[@dattamoortibhat7166]

Fentastic video!! I was searching solution for one of my report. Perfect time i got the solution. Thanks a lot patric😊

[@shashipaul6279]

HI Patrick, this is great in indeed however how we can use it for multiselect on a slicer. Let's say, I want to select 2 or 3 countries, then how we can do it? I am having a requirement to create such title so that if there is multiselect on any of the slicer, the title shows as per the selection instead of all countries or anything that we are multi-selecting. Please check if you can do this or create a VIDEO on

[@CCHSmathematics]

Amazing shirt Patrick!

[@sujoybardhan4751]

Hi Patrick, I have an scenario in straight table or in pivot table, where I want to give that kind of title or column header name for each column in reports. Is it possible, if possible please show in another video which will be very helpful. Regards, Sujoy