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!
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 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 :)
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.
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.
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!
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
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.
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
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 😊 , 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 😊
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.
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?
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.
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, 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
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"?
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!!!
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.
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)?
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?
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
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
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
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".
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.
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.
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?
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.
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 😅
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?
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. 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
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, 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!
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
Hi Sir, I am Newbie in PBI and I have problem. Please, can you help me, I want to filter a value with slicer. suppose I have table with three column, there are period, total revenue and total sales. And I want to make slicer that contain revenue and sales. How the solution?
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?
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
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"
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?
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
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 ..
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!
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 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! 👊
Please make a video with multiple values selected?
Hi Patrick, great video as always!
Can you provide the shortcut to translate the formula into dax format?
Thanks!
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 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
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.
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!
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 your video! I'm using a combination of your suggested SELECTEDVALUES with Dynamic Values in Text boxes!
Thanks a ton Patrick! This feature is really useful! Your videos always help me to take my Reports to the next level!🔥
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.
Great use of selected/combine values function! I always used the simple & concat but your way looks more elegant!
This is bananas 😂
Awesome work guys, super usefull tips. Keep the good work.
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 Patrick, great video. It is exactly what I was looking for. Thanks for your help. Congratulations
Hi,
How do you build that column chart with the line series being horizontal through the whole category and vertical between categories
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
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 😊 , 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 😊
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.
Thank you for sharing all your tips and tricks 😅 Very useful and helpful
Thanks for saving me a lot of frustration and time trying to figure this out.....
Most welcome Fred! 👊
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 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!
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.
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?
Patrick...you are a life saver! Kudos to you and the team!
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
As always, just what I needed when I needed! WHAT THE FRENCH TOAST??!?!! You are the best Patrick.
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?
Fantastic video! thanks so much for being so thoughtful and thorough!
Great tip, will try it out tomorrow 😎thanks Patrick!
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"?
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.
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!!!
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 Patric,
great learning as always.
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)?
I am finding this way to make dynamic title, thanks for great method.
Hello, How did you get the layout look with the drop shadows?
Great video Patric!!!, that's exactly what I need right now, thanks a lot!
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?
This is awesome, keep up the great work, love you video's - i have learned so much watching your videos. Thanks so much!
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
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
You are a treasure Patrick ! Thanks a lot !
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
Hi man! I have a pain about renaming measures in the tabular section, what do you think about that ?
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 :)
Love your videos and the vibe you create :)
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 a lot Patrick it really helps a lot all your content
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.
Great content and love your enthusiasm - major help, thanks!
I love this. I'm putting this in practice this week. Great work!
Patrik, you are always making me "WOW", LOVE your videos guys.XOXO
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.
Thanks Patrick this is really helpful!!!
Thanks for this Patrick - really helpful for me as I transition to Power BI from Tableau!!
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?
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.
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 😅
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?
Hi Patrick .How do you formatting code ? what's shortcut ?
This is good for me being a new Power BI user.
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?
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
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?
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
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, 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!
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/
hi Patrick
Can you guide how to make this kind of combo chart where line is in a structured way
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
Hi Sir, I am Newbie in PBI and I have problem. Please, can you help me, I want to filter a value with slicer.
suppose I have table with three column, there are period, total revenue and total sales.
And I want to make slicer that contain revenue and sales. How the solution?
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. :)
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?
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
Can u able to help me to get, How to pass report from other report by using selected measure in Power BI
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"
Alway a fountain of DAX knowledge. Thanks Patrick
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?
Thank you so much Patrick!!
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.
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
This is amazing, thank you Patric!
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, Can you please create a video on what are the resposibilities of a power BI Architect
How can we make Australia and France for example if we select two or more countries?
How to do this when using analysis server tabular mode?
Awesome information, thanks!
If you have several categories chosen, can you indicate all choices?
Hi Patrick, great stuff! What's the difference between COMBINEVALUES and CONCATENATE(X) here?
What a great video!! nice one bro!
This really bananas Tks Patrick!