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!
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 :)
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
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!!
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"
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.
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.
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'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 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!
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...
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.
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".
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.
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.
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, 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.
DAX Studio or Tabular Editor, using external tools. Watch the video on Calculation Groups ruclips.net/video/vlnx7QUVYME/видео.html, in that video at 4:40 he uses the button to auto format DAX.
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?
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.
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!!!
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?
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?
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, 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
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
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?
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 😅
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 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
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?
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)?
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.
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.
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!
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! 👊
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
Please make a video with multiple values selected?
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!!
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
Hi Patrick, great video as always!
Can you provide the shortcut to translate the formula into dax format?
Thanks!
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"
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 for your video! I'm using a combination of your suggested SELECTEDVALUES with Dynamic Values in Text boxes!
You are a treasure Patrick ! Thanks a lot !
Great use of selected/combine values function! I always used the simple & concat but your way looks more elegant!
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 a ton Patrick! This feature is really useful! Your videos always help me to take my Reports to the next level!🔥
As always, just what I needed when I needed! WHAT THE FRENCH TOAST??!?!! You are the best Patrick.
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
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!
Fantastic video! thanks so much for being so thoughtful and thorough!
This is bananas 😂
Awesome work guys, super usefull tips. Keep the good work.
Hi Patrick, great video. It is exactly what I was looking for. Thanks for your help. Congratulations
Hi Patric,
great learning as always.
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.
Thanks for saving me a lot of frustration and time trying to figure this out.....
Most welcome Fred! 👊
Great tip, will try it out tomorrow 😎thanks Patrick!
I am finding this way to make dynamic title, thanks for great method.
Thanks a lot Patrick it really helps a lot all your content
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!
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
Thanks Patrick this is really helpful!!!
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.
Great video Patric!!!, that's exactly what I need right now, thanks a lot!
Love your videos and the vibe you create :)
Patrik, you are always making me "WOW", LOVE your videos guys.XOXO
I love this. I'm putting this in practice this week. Great work!
Thanks for this Patrick - really helpful for me as I transition to Power BI from Tableau!!
This is awesome, keep up the great work, love you video's - i have learned so much watching your videos. Thanks so much!
Thank you so much Patrick!!
Great content and love your enthusiasm - major help, thanks!
Alway a fountain of DAX knowledge. Thanks Patrick
Awesome information, thanks!
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.
This is amazing, thank you Patric!
This really bananas Tks Patrick!
you rock Patrick, thanks for great info !!!
Fentastic video!! I was searching solution for one of my report. Perfect time i got the solution. Thanks a lot patric😊
What a great video!! nice one bro!
This is good for me being a new Power BI user.
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/
This is bananas at 10:25 :D
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.
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.
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.
Dude you rock! live from Redstick, LA
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, 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.
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 :)
excelente explicación , saludos desde Honduras
¡Nosotros apreciamos eso! Gracias por ver 👊
Amazing shirt Patrick!
LOVE IT! Thank you.
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 ruclips.net/video/vlnx7QUVYME/видео.html, in that video at 4:40 he uses the button to auto format DAX.
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?
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.
It makes me feel a little better I'm not the only one asked to spell out even the most obvious reports.
Amazing! Thank you!
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!!!
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?
Great Video
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?
YOOOOOOOOOO this is lit, subscribed
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 😊
New trick again. Tq mas bro
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
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
Hi Patric, Can you please create a video on what are the resposibilities of a power BI Architect
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?
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
Hi,
How do you build that column chart with the line series being horizontal through the whole category and vertical between categories
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?
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 ..
Very useful.
Thanks alot
Most welcome 👊
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
thanks guys
nice video
Awesome, you're magic man
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. :)
Hello, How did you get the layout look with the drop shadows?
Nice. I'm off to use this.
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?
Hi Patrick .How do you formatting code ? what's shortcut ?
Hi man! I have a pain about renaming measures in the tabular section, what do you think about that ?
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)?
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.
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.
Saved in the Bananas folder 😊
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?
Video begins @ 2:00
And as of 2022 I believe the feature is already implemented for Title
hi Patrick
Can you guide how to make this kind of combo chart where line is in a structured way