Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

uzuntasgokberk

How to Create Dynamic Titles in Power BI

Creating dynamic titles in Power BI is building a DAX measure. This measure ensures that when a slicer is selected, the title displays “Selected KPI Name – Yearly Monitoring”. If no slicer is chosen, the title defaults to “All KPIs Yearly Monitoring”. This approach makes dashboards more interactive and user friendly, helping stakeholders quickly identify the context of the report.

 

Step-by-step explanation DAX code

1) _kpiname = Builds a comma-separated list of the KPI names currently selected in the slicer:

VALUES(MANAGEMENT_All_Parameter_Text[MANAGEMENT_Actual_Values]) returns the distinct selected items.

CONCATENATEX(…) joins them into a single string.

2) filtreK_ = Chooses between the user’s selection and a default label:

TRUE → use _kpiname (the selected KPIs), FALSE → use "All KPIs"

3) Return (dynamic title) = Appends the monitoring label to form the final title:

uzuntasgokberk_0-1757880754117.png

With Visualization Pane you can give your measure.

uzuntasgokberk_1-1757880774029.png

Select the measure.

uzuntasgokberk_2-1757880789181.png

Whenever a slicer selection is made, the report title will dynamically update to reflect the chosen values.

uzuntasgokberk_3-1757880806876.png