Hello everyone,
If you want to create a dynamic title Power BI, follow these steps:
Using Sample Superstore dataset,
1. Create a measure and give it a name for example “Dynamic Title”:
Dynamic Title = SELECTEDVALUE(Orders[Sub-Category],”All Sub-Categories”)
This is a simple expression which will return the name of the Sub-Category if only one Category exist in the filter context, if not, it will return the text “All Sub-Categories”.
2. From the visualization Pane, add a Card, and then drag your created measure (Dynamic Title) into the Fields.
3. Now, for example, we want to create a bar chart to show Sales by Sub-Categories:
4. Now, if you select each Sub-Category, the card will show the name of the selected Sub-Category. and If nothing is selected, it shows All Sub-categories.
