DYNAMIC TITLES based on SLICER SELECTION in Power BI

Показать описание

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

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ 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 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* 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

Рекомендации по теме

Комментарии

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

saitenspieler

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

juniorakotshi

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

henrivuolle

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

yangkijin

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

yeraldo

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

sivaram

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

RajendraPatel.

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?

mohamedaboobackersiddique

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

haripn

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

powerbikz

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

gambu

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

ujangsonjaya

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

MaanEid

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

jsmel

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!

jadonnorville

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

TheCnshn

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

EricaDyson

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

kostaszogo

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

user_santosh-ffdhgjx

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

narendersingh

DYNAMIC TITLES based on SLICER SELECTION in Power BI

DYNAMIC TITLES based on SLICER SELECTION in Power BI

DYNAMIC TITLES based on SLICER SELECTION in Power BI Desktop

Dynamic titles with multiple slicers or filters in Power BI

DYNAMIC Titles based on multiple Slicer selection | Multi-select Dynamic Titles | PBI interview QnA

Dynamic Titles based on slicer selection in Power BI

Dynamic Title Based on Slicer Selection in Power BI | Power BI Tips | PowerBI

Power BI Dynamic Title Based on Slicer | Show Top N and Other Items in Visual Title -Power BI

Creating a dynamic title based off slicer selections in Excel 📊

How to Create a Simple DYNAMIC Dashboard in Excel!

How to create dynamic titles that change based on filter selections in Tableau

Dynamic Title for Visualization with Multiple Selection from Slicer

Power BI: Dynamically changes chart title based on slicer selection | Selected Value as Chart title

Dynamic Page Header or Title based on Slicer Selection

Dyamically change the title of a visual in Power BI | Power BI for beginners

Display columns dynamically using a Slicer in PowerBI | Tutorial | MiTutorials

NEW! Dynamic Slicers with Fields Parameters | ULTIMATE EXAMPLE in Power BI

Dynamic column headers in Power BI based on a slicer selection

CHANGE VISUALS BASED ON SLICER SELECTION IN POWER BI | CHANGE VISUALS WITH DYNAMIC TITLE | SHOW/HIDE

Dynamic Titles in Power BI Desktop

New Feature: Slicer to choose which columns to display on chart using Fields Parameter in PowerBI

Dynamic Columns Based on Slicer Selection in Power BI

Change the visual axis value based on dynamic measure slicer !

PowerBI, slicer variables by unpivot data, dynamic title based on slicer's value.

How to Get Excel Slicer Selections as Text - Dynamic Report Titles from Slicer Selections