Hi Learner, I am back with New Content of Single selection dynamic Filter.
The below visual have static title that should never change. but client how to make this visual title as dynamic based on country filter on slicer the title should be change. Lets go to step by step to follow the same. how to make static title to dynamic.
Based on the filter selection the title of the visual will auto change.
Please follow the process step by step.
Steps 1:
Measure,
Dynamic Title for single selection = " Total sales in "& SELECTEDVALUE('sales'[Country], "All Countries")
Step 2.
Please follow the step for conditional formatting for visual title.
- Select the visual where you have applied to dynamic Title.
- Navigate to visualization Pane and click on format visual.
- Click on Title.
- Click on the Conditional Function fx.
- For format Style please select field value.
- Below to format please select the measure that you have created for dynamic selection.
- Click Ok and done.
Now Done.
How its Working below are the example for dynamic title.
Above Visual Title will be changed based on the slicer selection.