Today we are going to look at how to make visual titles dynamic.
It’s an easy process and helps in making your visual more informative and dynamic in a way that the slicer selections would get reflected in the visual title as below:
Read on to find out how to implement it.
We would be using the conditional formatting feature for dynamic changes.
All the steps are explained in relation to the above example.
Step 1:
Firstly, we need to create a measure to capture changing slicer values as below:
You can change the prefix as per your requirement.
Step 2:
The next step would be to apply this measure as conditional formatting so that slicer changes start getting reflected in the visual title.
Go to the general section under the title tab as below:
Step 3:
Click on the “fx” conditional formatting button as shown in the above image.
That will open up a dialog box as below:
Step 4:
Use the second drop-down, find the measure that you created earlier, and select it as shown below:
Following the above steps, you will be able to implement dynamic visual titles making them more informative.
Author By
Gaurav Lakhotia
Gaurav holds an MBA in Business Analytics. As a data geek and avid learner, he has earned accolades including Microsoft Certified Data Analyst, Microsoft Certified Azure Administrator, and active Power BI Community contributor. He is also a Microsoft Certified Trainer. With critical thinking and project delivery skills, he strives to achieve customer delight in Data Analytics projects. Gaurav loves travelling with friends when he is not busy working on data.
