POWER BI:- Dynamic And Multi-Selected Dynamic Title

• In this article, we learn about Dynamic and Multi-Selected Dynamic title. Here I have already created a dashboard by using Stacked Bar Chart, Slicer and Pie chart.
• The dashboard helps to simplify complex data. This dashboard helps to visualize product data.

DASHBOARD

DYNAMIC TITLE

• I want to change the title of the visualization component as per we selecting the year.
• If we select the 2018 year so the title will be changed by product name and cost for the year 2018.
• Firstly we need to write a DAX query for the dynamic title. So right-click on the table and click the New measure or else in Home tab go to the New Measure option.

• After that, we write a DAX query.

MEASURE: DYNAMIC

• Thereafter we select the visualization component and go to the Title in the Format.
• When we move the mouse over the right side of the Title text there are three dots shown click by that dots and choose option Conditional Formatting.

SELECT CONDITIONAL FORMATTING

• When we clicking on Conditional formatting new pop up window is open in that window we select our measure and click on ok button. And we apply the same steps by another visualization.

SELECT MEASURE

• Now If we check the title there are two option conditional formatting and revert to default. Revert to default option helps to revert to the original position.

FORMAT

• Now we check dynamic title apply or not. when we select the year 2018 the title changed by selected year.

DYNAMIC YEAR ON THE DASHBOARD

• Dynamic title only works on a single value that means if we select 2018 and 2019 then it doesn’t display any value. So we apply the Multi-Selected title on it.

MULTI-SELECTED DYNAMIC TITLE

• To multi selecting title we need to write DAX on measure.

MEASURE: MULTI-SELECTED DYNAMIC

• Then we again goto title and this time we select multi-selected measure. And click on ok.

SELECT MEASURE

• Thereafter we select a multi-selected measure on another visualization component that is the pie chart.
• Now we select multiple years on the dashboard.

MULTI-SELECTED DYNAMIC YEAR

• And we choose Select All option then it shows the All Year.

DASHBOARD

If you are new to Power BI start with the following must-watch video:-