Dynamic titles with multiple slicers or filters in Power BI
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- 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/dy...
📢 Become a member: guyinacu.be/me...
*******************
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/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#PowerBI #GuyInACube
Please make a video with multiple values selected?
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
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!
Hi Patrick, great video as always!
Can you provide the shortcut to translate the formula into dax format?
Thanks!
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! 👊
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"
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.
Hi Patric, what if you multi-select values in one of the filter ?
I've used something like this to handle multi selections in a filter.
CONCATENATEX(
VALUES(Table[Column]),
Table[Column],
", ",
Table[Column],
ASC
)
Hope that helps
@@stevenfoster5799 I wish this worked for DirectQuery as this is exactly what I have been looking for...
@@stevenfoster5799 How did combine it with Dynamic Title shown on the video? When I selected more than one category, it brings All categories. Looking forward to hearing from 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 use of selected/combine values function! I always used the simple & concat but your way looks more elegant!
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!!
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.
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 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
I am finding this way to make dynamic title, thanks for great method.
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
Help needed!
Selected Parameter = maxx(filter('Date Value', 'Date Value'[Date Value Order] = SELECTEDVALUE('Date Value'[Date Value Order])), 'Date Value'[Date Value Fields])
This returns the name of selected column in slicer created using field parameter.
Now based on the selected column name wants to calculate dates that falls in last 180 days on that particular column.
Last 180 days flag = IF([Selected Parameter] > (TODAY()-180),"1","0")
This is giving error, value coming from selected parameter is not considered as column but is considered as text. So it's not matching up with today()-180 days condition.
The values in 4 different columns that are in slicer are in date time format.
Value coming from selected parameter is not considered as column but is considered as text. So, it's not matching up with today()-180 days condition.
If I directly consider creating column the formula is working fine. Please suggest any alternative appraoch.
Thanks a ton Patrick! This feature is really useful! Your videos always help me to take my Reports to the next level!🔥
It makes me feel a little better I'm not the only one asked to spell out even the most obvious reports.
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?
Thanks for saving me a lot of frustration and time trying to figure this out.....
Most welcome Fred! 👊
This is bananas 😂
Awesome work guys, super usefull tips. Keep the good work.
This is good for me being a new Power BI user.
Great tip, will try it out tomorrow 😎thanks Patrick!
I've been using Measure = "Text: "&IF(ISFILTERED('Table'[Column]),SELECTEDVALUE('Table'[Column],"Multiple Selected"),"ALL") for a while now. Downside has been if the slicer is the same as report filter, so for example department short name is filtered to say 6/10. Then the title displayed "multiple selected" when none were, instead of "all".
Yeah you would need to account for that in your DAX.
Thanks for your video! I'm using a combination of your suggested SELECTEDVALUES with Dynamic Values in Text boxes!
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 😊
This is an awesome. This video saved me sooooo much time. Thank you for posting it!!!!
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!!!
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.
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!
Thanks Patrick this is really helpful!!!
Thank you for sharing all your tips and tricks 😅 Very useful and helpful
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.
Great! Can you also show selected years in the title if 2 years are selected? So "sales for 2020 + 2021"?
I have exactly the same problem :)
Hi Patrick, great video. It is exactly what I was looking for. Thanks for your help. Congratulations
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.
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.
As always, just what I needed when I needed! WHAT THE FRENCH TOAST??!?!! You are the best Patrick.
Hi,
How do you build that column chart with the line series being horizontal through the whole category and vertical between categories
Hi Patric,
great learning as always.
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.
You are a treasure Patrick ! Thanks a lot !
Fantastic video! thanks so much for being so thoughtful and thorough!
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?
This is bananas at 10:25 :D
What about when you select Bikes AND accessories......? A product manager may want to look at their entire portfolio which is more than a single category.....but less than all.....can it filter for multiple selections?
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
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 ..
Thanks for this Patrick - really helpful for me as I transition to Power BI from Tableau!!
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?
Thanks alot
Most welcome 👊
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?
I love this. I'm putting this in practice this week. Great work!
Great content and love your enthusiasm - major help, thanks!
Awesome information, thanks!
This is awesome, keep up the great work, love you video's - i have learned so much watching your videos. Thanks so much!
hi Patrick
Can you guide how to make this kind of combo chart where line is in a structured way
Thanks a lot Patrick it really helps a lot all your content
Great video Patric!!!, that's exactly what I need right now, thanks a lot!
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
Patrik, you are always making me "WOW", LOVE your videos guys.XOXO
Hi Patric, Can you please create a video on what are the resposibilities of a power BI Architect
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
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?
Hello, How did you get the layout look with the drop shadows?
Hi Patrick, how did you do the auto DAX formatting on the fly?
Thank you so much Patrick!!
Love your videos and the vibe you create :)
Alway a fountain of DAX knowledge. Thanks Patrick
Nice. I'm off to use this.
This really bananas Tks Patrick!
What's the shortcut for DAX formatting?
No shortcut :) copy and paste from notepad...
@@GuyInACube Haha awesome, thanks
DAX Studio or Tabular Editor, using external tools. Watch the video on Calculation Groups th-cam.com/video/vlnx7QUVYME/w-d-xo.html, in that video at 4:40 he uses the button to auto format DAX.
Hi Patrick .How do you formatting code ? what's shortcut ?
Fentastic video!! I was searching solution for one of my report. Perfect time i got the solution. Thanks a lot patric😊
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"?
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 😅
Amazing Dax
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?
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/
you rock Patrick, thanks for great info !!!
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?
these videos get better every time I see them, dummy question, If I just concatenate them, will that work? isn't it?
That's really all we are doing. If you use CONCATENATE vs. COMBINE, check the perf for your model to see which is better.
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. :)
excelente explicación , saludos desde Honduras
¡Nosotros apreciamos eso! Gracias por ver 👊
How to do this when using analysis server tabular mode?
What if user selected multiple values from the filter? Let say if user selected year 2019 and 2020?
What about the slicers that have a min and max value like those with a slider - dates (date from and date to), or currency ( with from and two options.)
Help! I have been able to capture the single value ones, but not those with from and to values…
Hey Patrick, I love this dynamic title feature. There is only one issue. Every filter is cascading in one way or another. For example I have Region, Country. When I select a country without selecting any regions before hand my text box/title looks like "All Regions > United States" which is not very user friendly. Is there a solution for the region to be shown even if it was not selected? I used the Quick measure thing from your other video and the advice here. Let me know your thoughts.
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!
Nice trick👌
Please explain how to do for multiple selections?
I was about to ask this question as that is one of our asks as well
I've used something like this to handle multi selections in a filter.
CONCATENATEX(
VALUES(Table[Column]),
Table[Column],
", ",
Table[Column],
ASC
)
Hope that helps.
Can u able to help me to get, How to pass report from other report by using selected measure in Power BI
Hey Patric, I am from Bangladesh 🇧🇩, learned a lot from your videos. I need a help, how do I keep selecting latest date on a slicer?
Please vote for this idea to put a default value: ideas.powerbi.com/ideas/idea/?ideaid=39ba67cf-724e-4b6c-9906-51163749f759
This is amazing, thank you Patric!
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 man! I have a pain about renaming measures in the tabular section, what do you think about that ?
How can we make Australia and France for example if we select two or more countries?
Very useful.
If you have several categories chosen, can you indicate all choices?