DYNAMIC TITLES based on SLICER SELECTION in Power BI

Подписаться 225 тыс.

Просмотров 98 тыс.

50% 1

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 RU-vid: 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

Наука

Опубликовано:

7 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 125

@j3sm0el 2 года назад

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

@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 ;)

@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!!

@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!!

@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!! 😀

@henrivuolle7970 Год назад

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

@yangkijin 2 года назад

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

@user_santosh-ff7dh6gj3x Год назад

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

@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 😉

@powerbikz9023 2 года назад

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

@HowtoPowerBI Год назад

Thanks Sumbat, glad to hear you think so!

@hari27pn Год назад

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

@sivaram5127 Год назад

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

@peterhoelzel2448 2 года назад

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

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

@cartmanbrah2937 2 года назад

many thanks for this !

@robertanderson2552 2 года назад

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

@HowtoPowerBI 2 года назад

Great to hear! thx for watching Robert

@nareshpatel1035 3 года назад

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!!

@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!

@moeeljawad5361 11 месяцев назад

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

@romustdie 2 года назад

Awesome information, thanks!

@HowtoPowerBI 2 года назад

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

@nkosanandindwa8304 9 месяцев назад

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

@SharoonGill1 3 года назад

That is awesome work and great explanation

@HowtoPowerBI 3 года назад

thx Sharoon! 😃

@brucemcminn5169 Год назад

Great video!!😃

@MiguelMartinez-sh8gz 2 года назад

Great video, thanks for the help

@HowtoPowerBI 2 года назад

Glad it helped thx Miguel! 😊😀

@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 :)

@shawnebrown Год назад

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

@kostaszogo21 2 года назад

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

@HowtoPowerBI 2 года назад

Hahah hillarious! Thanks 🙏

@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

@fulyaulutas4599 3 года назад

thank you

@TheCnshn 5 месяцев назад

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

@rogeriopsvalle 2 года назад

Just great!

@HowtoPowerBI 2 года назад

Thanks a lot ☺️

@kennethstephani692 2 года назад

Great video!

@HowtoPowerBI 2 года назад

Thanks Kenneth!

@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. 🙂

@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 !!!!!!!

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

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

@srinivasp2886 Год назад

Very useful ........

@HowtoPowerBI Год назад

Thx! Happy to hear this

@PedroCabraldaCamara 3 года назад

very gooooood!!!

@HowtoPowerBI 3 года назад

thanks Pedro!

@Do_Choroszczy_na_badania 3 года назад

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

@HowtoPowerBI 3 года назад

defiinitely on my list 🙂

@sheilahart7528 9 месяцев назад

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 9 месяцев назад

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

@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)

@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!!!

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

@jayeshsuthar9198 3 года назад

Great video

@HowtoPowerBI 3 года назад

Glad you enjoyed it, thanks!

@gambu4810 2 года назад

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

@HowtoPowerBI 2 года назад

hahaha thx Gambu!!!! 😄

@knowtechwithaman7254 Год назад

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

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

@daianamariatamas9934 10 месяцев назад

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.

@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

@oladman9058 Год назад

Wow!

@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,

@satyakanungo4176 2 года назад

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

@user-ig9yg2jc8r 11 месяцев назад

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

@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!

@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

@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 😁

@moeeljawad5361 24 дня назад

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 24 дня назад

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)

@cheikhhakim5864 3 месяца назад

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 3 месяца назад

Here you go ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VrVqseNAVH4.html

@cheikhhakim5864 3 месяца назад

@@HowtoPowerBI lot of thanks

@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.

@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

@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!

@sushilpatel7013 Год назад

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

@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

@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

@karanmalkhede6689 Год назад

How to show different names or title instead of customer names in visual

@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