Dynamic titles with multiple slicers or filters in Power BI
Вставка
- Опубліковано 25 сер 2020
- 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 - Наука та технологія
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!
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!!
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
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.
Thanks a ton Patrick! This feature is really useful! Your videos always help me to take my Reports to the next level!🔥
Great use of selected/combine values function! I always used the simple & concat but your way looks more elegant!
Please make a video with multiple values selected?
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 :)
hahaha love it! 👊
Patrick...you are a life saver! Kudos to you and the team!
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.
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.
I love this. I'm putting this in practice this week. Great work!
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!
This is awesome, keep up the great work, love you video's - i have learned so much watching your videos. Thanks so much!
Thanks for your video! I'm using a combination of your suggested SELECTEDVALUES with Dynamic Values in Text boxes!
This is bananas 😂
Awesome work guys, super usefull tips. Keep the good work.
Fantastic video! thanks so much for being so thoughtful and thorough!
Hi Patrick, great video. It is exactly what I was looking for. Thanks for your help. Congratulations
Great video Patric!!!, that's exactly what I need right now, thanks a lot!
Great tip, will try it out tomorrow 😎thanks Patrick!
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"
Love your videos and the vibe you create :)
Great content and love your enthusiasm - major help, thanks!
This is an awesome. This video saved me sooooo much time. Thank you for posting it!!!!
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
Thank you for sharing all your tips and tricks 😅 Very useful and helpful
Patrik, you are always making me "WOW", LOVE your videos guys.XOXO
This channel is fantastic! I know most of the tricks that are showed here. I just watch because its sooo well explained!
Hi, Can you tell the measure definition if multiple values are being chosen?
abhay verma i just count them and display “multiple selection” if selection count is > 1 if that is what you are asking
This is amazing, thank you Patric!
I am finding this way to make dynamic title, thanks for great method.
Hi Patric,
great learning as always.
Thanks Patrick this is really helpful!!!
Thanks a lot Patrick it really helps a lot all your content
Hi Patrick, great video as always!
Can you provide the shortcut to translate the formula into dax format?
Thanks!
Alway a fountain of DAX knowledge. Thanks Patrick
Thanks for this Patrick - really helpful for me as I transition to Power BI from Tableau!!
Awesome information, thanks!
Thank you so much Patrick!!
As always, just what I needed when I needed! WHAT THE FRENCH TOAST??!?!! You are the best Patrick.
You are a treasure Patrick ! Thanks a lot !
Thanks for saving me a lot of frustration and time trying to figure this out.....
Most welcome Fred! 👊
LOVE IT! Thank you.
What a great video!! nice one bro!
you rock Patrick, thanks for great info !!!
Dude you rock! live from Redstick, LA
This really bananas Tks Patrick!
Amazing! Thank you!
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?
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
New trick again. Tq mas bro
Great Video
Awesome, you're magic man
Very useful.
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.
This is good for me being a new Power BI user.
thanks guys
nice video
Amazing shirt Patrick!
Amazing Video, Multi Selection would be awesome too.
Thanks a lot for your outstanding Videos - my first source for Power BI
Multi selection could be done with some extra DAX. We specifically didn't cover that in this video though.
This blog post covers dynamic chart titles with multi-select blog.crossjoin.co.uk/2016/04/25/dynamic-chart-titles-in-power-bi/
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?
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?
It makes me feel a little better I'm not the only one asked to spell out even the most obvious reports.
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.
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...
Same here. Curious to know if its even possible
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.
Amazing Dax
Hi,
How do you build that column chart with the line series being horizontal through the whole category and vertical between categories
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. :)
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.
Fentastic video!! I was searching solution for one of my report. Perfect time i got the solution. Thanks a lot patric😊
YOOOOOOOOOO this is lit, subscribed
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!
Awesome.
excelente explicación , saludos desde Honduras
¡Nosotros apreciamos eso! Gracias por ver 👊
Hi Patric, Can you please create a video on what are the resposibilities of a power BI Architect
Hey......thanks for the trick 👌
This is bananas at 10:25 :D
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
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
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 😅
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?
Cool!
Hi Patrick, great stuff! What's the difference between COMBINEVALUES and CONCATENATE(X) here?
pretty cool
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?
Nice function
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!!!
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
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!
Thanks alot
Most welcome 👊
Hi Patrick, how did you do the auto DAX formatting on the fly?
Love the shirt
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
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 😊
Hello, How did you get the layout look with the drop shadows?
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?
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?
Hi Patric, This is a great video, is this work in Advance filter?
Hey I am a big fan of watching your videos during the progress of learning , could you please provide a training based on dax ? I would like to prefer the online training . let me know the cost of the training ..
hi Patrick
Can you guide how to make this kind of combo chart where line is in a structured way
This is awesome Patrick. However, how does one do it when they have two filters that are almost the same like a month filter and a quarter filter. It's obvious one cannot use the two filters at the same time. The OR functionality should assist here. What do you think?