DYNAMIC TITLES based on SLICER SELECTION in Power BI

Рет қаралды 95,686

Күн бұрын

Learn how to create a Dynamic Title in Power BI based on the slicer selection.
Dynamic titles can be very useful and improve the usability of the report. Have a look at 5 different ways to put your selected filter in title!
Welcome to my visualization title tips video :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:40 Creating a dynamic title using SELECTED VALUE function
2:52 Measure for title needs to return text value
4:23 Showing multiple selected items from slicer in the chart title
9:09 Creating a dynamic title using the SWITCH function
10:40 Returning the selection from multiple slicers in the chart title
12:00 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZfaq: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX

Пікірлер: 125

@saitenspieler3489 Жыл бұрын

Perfect, thanks a lot! One additional idea from my side. In case you would like to combine year and month automatically, e.g. to avoid manual adjustments in your page headers, you can also include such measures into the text fields. Here is an example, including the "what if you'd select all month" solution from your slicer. IF([FilterMonthNumber]="", COMBINEVALUES( " ", ""&RIGHT([FilterYear],2), "."&"Full Year" ), COMBINEVALES( " ", ""&RIGHT([FilterYear],2), "."&[FilterMonthNumber] ) )

@juniorakotshi2132 Жыл бұрын

This channel is a gold mine! I will keep digging ;)

@j3sm0el 2 жыл бұрын

Great Video! So well explained and covering all problems that could appear in the process. Keep up the good work :) Thanks!!!

@yangkijin 2 жыл бұрын

This is the best channel when I face hurdle in design dashboard. The BEST channel

@yeraldo05 3 жыл бұрын

I was literally looking at some dynamic titles videos and you just posted this awesome tutorial!! Thanks a lot mate!! 💯

@HowtoPowerBI 3 жыл бұрын

I saw you looking for the topic, so quickly created on for you 😉😋 thanks for watching Yeriel!

@yeraldo05 3 жыл бұрын

@@HowtoPowerBI That's what I call a Good Listener 👂👏. Keep the great videos coming mate!!

@fw3239 2 жыл бұрын

You helped me a lot! I could find what I wanted. Keep going! Great video!

@MaanEid Жыл бұрын

Amazing! it coveres eveything needed for dynamic Title :)Thanks!!

@henrivuolle7970 Жыл бұрын

This was awesome! Perfect use case for me is to build KPI with this about working hours low, in limits, too much

@user_santosh-ff7dh6gj3x 11 ай бұрын

Thanks a millon !! the idea you brings everytime it helps a lot.

@ujangsonjaya8348 Жыл бұрын

Hi Bas, many thanks, it's a pleasure following your tips. you are awesome

@EricaDyson 3 жыл бұрын

Very very very nice. Great explanation, just the right speed, and of course, super content! Thanks a lot

@HowtoPowerBI 3 жыл бұрын

Thank you so much Erica for watching!! 😀

@RajendraPatel. 3 жыл бұрын

Slicer is the key tool of Power bi 👍 Great learning.. thank you.! 😁👌👌

@HowtoPowerBI 3 жыл бұрын

thanks for watching Raj! can't live without them 😉

@peterhoelzel2448 Жыл бұрын

Hi Bas, many thanks, it's a pleasure following your tips. Is there a way to use a selected value from a graph instead of the value from the slicer? Again, thanks and best regards

@powerbikz9023 2 жыл бұрын

Thanks a lot for your videos. The best channel for Power BI.

@HowtoPowerBI Жыл бұрын

Thanks Sumbat, glad to hear you think so!

@hari27pn 11 ай бұрын

I just used the switch function and it worked like a charm for me.

@cartmanbrah2937 2 жыл бұрын

many thanks for this !

@stevenstanford8618 11 ай бұрын

Hi BAs, really enjoy your videos and they have enhanced my reports immensely. Is it possible to highlight or colour specific words or numbers in a dynamic title?

@robertanderson2552 2 жыл бұрын

Brilliant, many thanks for your video. Helped me in my job.

@HowtoPowerBI 2 жыл бұрын

Great to hear! thx for watching Robert

@yukil2294 2 жыл бұрын

Thank you! Very helpful!

@HowtoPowerBI 2 жыл бұрын

Glad it was helpful Yuki!

@jadonnorville9361 Жыл бұрын

excellent video, i have added dynamic natural language like titles to many of my reports from your guidance. Quick question, what should I do to show " Bluetooth Headphones, Cellphones & Computers". I'm trying to have it use natural language verbiage whereby if more than 1 is selected, there is an & between the last and second last selection and a comma in all other instances before. anyhelp here would be much appreciated!

@nkosanandindwa8304 8 ай бұрын

Bas is always on point ,this guy is genius 👏 👌 ..

@sivaram5127 Жыл бұрын

Hey, can i know how it works for date slicer with dates in between? Can we get selected dates range in the title??

@kostaszogo21 2 жыл бұрын

This guy is better than NETFLIX!!! Another amazing video! keep up the good work Bas!

@HowtoPowerBI 2 жыл бұрын

Hahah hillarious! Thanks 🙏

@moeeljawad5361 10 ай бұрын

Hello Bas, great video. I am wondering if there is a way to get in your measure, multiple selected values from a year slicer such as: whenever the year are consecutive, then the minyear-maxyear would be returned for that interval, and concatenated with other selected years that are outside of the interval. For example, imagine i have the range of years 2010-2023 in my year slicer. consider that the user has selected the years, 2012, 2013, 2014, 2017, 2019, 2020, 2021 then the measure should return 2012-2014, 2017, 2019-2021 Thanks

@brucemcminn5169 Жыл бұрын

Great video!!😃

@romustdie 2 жыл бұрын

Awesome information, thanks!

@HowtoPowerBI 2 жыл бұрын

Glad it was helpful! thx for watching!!! 😀

@mohamedaboobackersiddique7322 3 жыл бұрын

Thanks for this tip.just one more point to be more dynamic,instead of hard coding the 2020 as current year,it can be applied my max year right?

@HowtoPowerBI 3 жыл бұрын

Yes that would work :)

@MiguelMartinez-sh8gz 2 жыл бұрын

Great video, thanks for the help

@HowtoPowerBI 2 жыл бұрын

Glad it helped thx Miguel! 😊😀

@nareshpatel1035 2 жыл бұрын

Hey Bas, really explained well. Just want to solve one problem, for YTD values of Year/Quarter/Months selections I want to keep showing only latest Year/Quarter/Months in dynamic Title though multiple selections applied, Please help!!

@shawnebrown Жыл бұрын

Would love to know how to include only the values excluded from a slicer… this is awesome btw

@CJ-jc8tn 3 жыл бұрын

Another superb video from Bas. Was not aware of that COMBINEVALUES technique at minute 11. If you get a chance, would you mind attaching the PBIX file to your comments section. Thank you!

@HowtoPowerBI 3 жыл бұрын

Thanks CJ! I've added the download link to the description section. 🙂

@SharoonGill1 3 жыл бұрын

That is awesome work and great explanation

@HowtoPowerBI 3 жыл бұрын

thx Sharoon! 😃

@narendersingh2851 2 жыл бұрын

Hi First of all thank you very much for this amazing content. Please keep doing the good work man. Just one issue , i am not able to implement the " All Skills" concept< please help !!!!!!!

@fulyaulutas4599 3 жыл бұрын

thank you

@reasonistas 2 жыл бұрын

Thanks for the clarity on this topic. It seems we can't use the new field parameter SELECTEDVALUE to dynamically change the corresponding visual title. Is there a way to make this work?

@tenthhokage8564 2 жыл бұрын

Did you find an answer I have been looking forever

@TheCnshn 4 ай бұрын

Another nice one . Thanks . I have an issue. ISFILTERED did not work. It still shows all values for title.

@Do_Choroszczy_na_badania 3 жыл бұрын

nice one! Do you plan something about improving efficiency of the reports?

@HowtoPowerBI 3 жыл бұрын

defiinitely on my list 🙂

@chizuruoke1 5 ай бұрын

Hi Bas, I want to know if it's possible to make the dynamic title show between two selected years say, 1990 and 2000?

@gambu4810 2 жыл бұрын

I'm offended by those two dislikes at the top.

@HowtoPowerBI 2 жыл бұрын

hahaha thx Gambu!!!! 😄

@KathyGi 2 жыл бұрын

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"?

@kennethstephani692 2 жыл бұрын

Great video!

@HowtoPowerBI 2 жыл бұрын

Thanks Kenneth!

@snchan9894 2 жыл бұрын

You saved my life bro

@HowtoPowerBI 2 жыл бұрын

Saving lifes with Power BI is what i do 😄😂 im happy it helped! Thx for watching!!!

@rogeriopsvalle 2 жыл бұрын

Just great!

@HowtoPowerBI 2 жыл бұрын

Thanks a lot ☺️

@sheilahart7528 8 ай бұрын

Great video! Do you have any tips for how you would handle displaying the selection when the selected value in the filter is "greater than 30" for example?

@HowtoPowerBI 8 ай бұрын

build in logic like -> IF ( [measure] > 30, "text" )

@srinivasp2886 Жыл бұрын

Very useful ........

@HowtoPowerBI Жыл бұрын

Thx! Happy to hear this

@dominikreim7723 Жыл бұрын

How does this work for a heirarchy level? If you choose the 2 lines symbol to drill down a whole hierarchy level, the title changes automatically. But if you customize the automatic title, it wont work anymore. Which DAX measure can I use to change the title, so that it shows the selected field name of that hierarchy level?

@PedroCabraldaCamara 3 жыл бұрын

very gooooood!!!

@HowtoPowerBI 3 жыл бұрын

thanks Pedro!

@jayeshsuthar9198 2 жыл бұрын

Great video

@HowtoPowerBI 2 жыл бұрын

Glad you enjoyed it, thanks!

@txakomatic7051 2 жыл бұрын

Hey Bas, I have a question for you. Have you ever managed to get this working successfully with a Hierarchy in the slicer? When I select the lowest level of the slicer (in my case store names) the measure works. However, if I select a level higher (region - which automatically selects the stores) the filter doesn't work. Any idea how I may be able to fix this? Thanks for the video, was exactly what I was looking for a couple months ago!

@txakomatic7051 2 жыл бұрын

Solved. I added multiple ISFILTERED('table'[column]) representing each level of the hierarchy with an or "||." Here is the top part of the measure for anyone wants to see it. VAR __DISTINCT_VALUES_COUNT = DISTINCTCOUNT('Date'[Fiscal W#]) VAR __MAX_VALUES_TO_SHOW = 13 RETURN IF( ISFILTERED('Date'[Fiscal Year Name]) || ISFILTERED('Date'[Fiscal QTR Short Name]) || ISFILTERED('Date'[Fiscal Period Short Name]) || ISFILTERED('Date'[Fiscal W#]), IF( __DISTINCT_VALUES_COUNT > __MAX_VALUES_TO_SHOW,

@shruthil7913 2 жыл бұрын

Thanks Baz.. How to add title in two lines. Sub category in first line and year in second line. (Breaking the title in two lines)

@user-jo6dz7ie4o 7 ай бұрын

How we can add colour in this dynamic title measure if it is already used in another measure but i want to add colour only in this quick measure?

@knowtechwithaman7254 Жыл бұрын

let me know how can we create dynamic titles for measure switches as it creates dependency error if follow the same thing.

@Fierse77 2 жыл бұрын

This is just what I need but unfortunately when PBI is connected to tabular model I can't do this.. I can create the "Chart Title"-measure but I can't choose it from "Based on field"-dropdown list

@daianamariatamas9934 9 ай бұрын

I need to include an explanatory note in the reports. Does anyone have any ideas on how to do that? Each graph needs to have an analysis note, along with the option to show and hide this note.

@soniashah4744 3 жыл бұрын

I used the concatenated version of the measure to be able to select multiple items. I am facing an issue where if I have all multiple selected, the text box reflects that value, but when I deselect an item, it does not remove the name from the textbox. Example: Slicer has the following selections: Apples Bananas Watermelon Text box shows: "Apples, Bananas, Watermelon" Slicer changes selection to be: Apples Watermelon Text box shows: "Apples, Bananas, Watermelon" Any idea how to fix this? Thanks

@soniashah4744 3 жыл бұрын

Nevermind. I determined my issue. I created a column rather than a measure.

@ferdinandsantos6680 Жыл бұрын

Hi Bas, I have a matrix visual with 3 fields in the Rows section, say RowField1, RowField2, and RowField3. By default, the visual only displays the first field name as the "column label" for the row headers. I want to show the user what fields are in the row hierarchy when they expand. Is there a way to put into a measure the concatenated row field names so that I can use it as part of the visual's title? The idea is to make it dynamic so that if the user personalizes the visual and added a 4th row field, it will show in the concatenated field list in the title. Something like RowField1/RowField2/RowField3, then RowField1/RowField2/RowField3/RowField4 when a 4th field is added by the user. Thanks in advance!

@moeeljawad5361 3 күн бұрын

Hello Bas, i am trying to apply the instructions you gave in the video on a slicer that was created from Field Parameters, however i am getting the following error: MdxScript(Model) (48,14) Column['column_name'] is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression. Does your method works on slicers created by Modeling-> Modeling -> Fields

@HowtoPowerBI 3 күн бұрын

When you reference the first column of a fields parameter inside of a selectvalue function you get that error… instead use MAX() or alternatively use selectedvalue on another column (can be calculated column)

@satyakanungo4176 2 жыл бұрын

How to add Today's date in power bi title..like i.e. Data Refreshed on "Todays Date"..kindly suggest your video

@bbt6630 Жыл бұрын

Yes, Yes, Yes!!!

@ricardopinxt212 2 жыл бұрын

Superb. Can something like this be done on the header of measures in a matrix?? I have a measure that is linked to a slicer. Options are LBE1 to LBE4. Depending on the choice the column gives me different values. That is already very good, but the icing on the cake would be if the column header would change with the value that was chosen in the slicer.

@HowtoPowerBI 2 жыл бұрын

nice idea! don't think that is possible though 🙄😕

@ricardopinxt212 2 жыл бұрын

Nondeju 😉. Thats a pitty. As said that would be the icing. Then users would see the Actuals and the name of the Budget version they chose from the slicer next to each other in the visual. Kinda expected that to be an option if you can see what great features PowerBI already has. Maybe in future releases 😁

@oladman9058 Жыл бұрын

Wow!

@MoonShine-bs6cl Жыл бұрын

If I don't select anything in dynamic filter it should give me slicer header.. How to achieve... I'm getting dynamic filter by category but in select all I'm facing issues

@aryansena7290 3 жыл бұрын

Hi , Can you create a table as per slicer selection .. consider I'd column in a rows like 1,2,3,4. And a slicer using this I'd column.. now if I select I'd from slicer 3 then a table will be created which has all data with I'd 3. Please let me know if requirement is not clear

@HowtoPowerBI 3 жыл бұрын

You can only pass the selected value of a slicer to measures - not tables or calculated columns.

@aryansena7290 3 жыл бұрын

@@HowtoPowerBI so no work around for that.. thank you for replying

@user-ig9yg2jc8r 10 ай бұрын

Awesome, But how we can change column name dynamically based on filter selection

@cheikhhakim5864 2 ай бұрын

thak you sir, please can you explain an a video how we use the dynamic segmentation to do an aged balance ( for customer) by defining rules for example (Last 30 days; Between 31 and 60 days;Between 61 and 120 days;Between 121 and 180 days....) thanks in advance

@HowtoPowerBI 2 ай бұрын

Here you go kzfaq.info/get/bejne/jNiGpNaWs6e6eGg.html

@cheikhhakim5864 2 ай бұрын

@@HowtoPowerBI lot of thanks

@sathishkumar_bhutharaju 3 жыл бұрын

Great video! thanks for this video,can I get this pbix file?

@HowtoPowerBI 3 жыл бұрын

thanks Sathish! I have added the download link in the description 🙂

@sathishkumar_bhutharaju 3 жыл бұрын

@@HowtoPowerBICould you please cross check with your download link thanks!

@riazuddin7493 3 жыл бұрын

I have a column in my table name reason for leaving and based on that I want to add another column which is Volunteer attrition or Involunteer attrition i.e. if reason for leaving for an employee appears as Retired then the new column should show Involunteer attrition whereas for resignation it should show as volunteer attrition. Can you help me add this column please? Also how can I calculate the percentage of volunteer and involunteer attrition based on the total attrition for the whole year which is 1157.

@HowtoPowerBI 3 жыл бұрын

Hi Riaz, probably the easiest to add a conditional column in power query. Regarding the % calculation you could add measures like this: Attrition Voluntarily = CALCULATE(SUM(Data[Attrition]), Data[Reason]="Voluntarily") Attrition % of Total = DIVIDE([Attrition Voluntarily], ALLSELECTED(Data[Reason]))

@riazuddin7493 3 жыл бұрын

@@HowtoPowerBI thanks for your reply can you please also confirm that if I have a free power bi license then will I be able to create workspace and share reports with people within my organizations or will I require a Power BI Pro or Premium license also will the users whom I share report with be able to view edit and share report with other people using free license?

@HowtoPowerBI 3 жыл бұрын

@@riazuddin7493 no you as well as the receiver would need a pro license .. you could also go for a premium license, then you pay for capacity and pro license for people that need to publish

@riazuddin7493 3 жыл бұрын

@@HowtoPowerBI Hi thanks for your reply. Can you also please let me know if visual obtained through Q&A account for filters or they will show results from the whole dataset ignoring all filters. I tried but the filters are not working

@HowtoPowerBI 3 жыл бұрын

@@riazuddin7493 report filters also apply to the q&a visual

@tairusadiq3527 3 жыл бұрын

Is it possible to have the dynamic title show when a slide slicer (periodic) is used for year, this is the slicer to show the earliest and latest year. Instead of having a one year select slicer we use a slide that shows Minimum and maximum date

@HowtoPowerBI 3 жыл бұрын

Yes, just adjust the measure that you use ... something like this: Chart Title - Years Selected = VAR MinYear = YEAR(MIN(dimDate[Date])) VAR MaxYear = YEAR(MAX(dimDate[Date])) VAR Prefix = "Sales for " VAR Result = IF( MinYearMaxYear, Prefix & MinYear & " to " & MaxYear, Prefix & MinYear ) RETURN Result

@tairusadiq3527 3 жыл бұрын

@@HowtoPowerBI Once again, you made it look easy. Big thumbs up

@tomelner 2 жыл бұрын

@@HowtoPowerBI thank you!!! Now I just need to work out how to show the exact dates instead of a year range

@tomelner 2 жыл бұрын

Which I've done... for anyone else I replaced the YEAR with DATEVALUE

@sushilpatel7013 Жыл бұрын

If user selects 2020, 2021, and 2022, how do you make it display "2020-2022"

@karanjeetwaraich3210 3 жыл бұрын

Is there any way to give range of values in dynamic title?

@HowtoPowerBI 3 жыл бұрын

Hi Karanjeet, yes - that would work in the same way .. so you would have something like this Title = "Range: "&MIN(financials[Price]) & " - " & MAX(financials[Price] )

@karanjeetwaraich3210 3 жыл бұрын

@@HowtoPowerBI thanks for your reply and your content is very helpful, but my need is different... Suppose we have a month column and we want heading on selecting jan, feb, mar and dec like that : "Jan-Mar, Dec".... Could you please help me with this. Im not an expert in powerbi.. I found a video but unable to understand it properly.

@HowtoPowerBI 3 жыл бұрын

logic would be the same. you need a measure that returns the concatenated list of months. You can then use that measure for conditionally formatting the title. You can use the quick measure to create the concatenated list so that you dont have to bother with dax :)

@karanjeetwaraich3210 3 жыл бұрын

@@HowtoPowerBI will it be dynamic for any range of months?

@HowtoPowerBI 3 жыл бұрын

@@karanjeetwaraich3210 yes