Forum Discussion
Dynamic Titles
The title on a visual can't really work that way, but you might be able to fake something that looks like it. Leave title turned off for the visual and put a card visual behind it where the title should appear. Put the same visual level filters on the card as you have on the other visual and use a measure to concatenate a title using those filter criteria. The specifics from here will vary depending on exactly what you're doing. This all assumes that the filters applied only to the chart in question are not applied anywhere else on the page, and that these columns aren't going to also be further filtered by those other selections on the page.
Example:
A line chart that shows total sales for the last 90 days for product category X. The line chart has only the measure Total Sales as its value and uses DateTable[Week] on its axis. The line chart has two visual level filters:
- DateTable[DayDiff] is greater than or equal to -90 and less than 0
- SalesTable[Category] = "X"
To give it a title generated by the filters on the chart, I created this measure:
Sales90XTitle = "Total Sales Last " & DISTINCTCOUNT(DateTable[Date]) & " Days, Category " & LASTNONBLANK(SalesTable[Category], 1)
I created a card visual and set the card to have the same two filter criteria listed above, put the card above the line chart where the title goes, and put that measure in the card. The card reads "Total Sales Last 90 Days, Category X". It ignores other selections because they are not called by the concatenation. So selecting a sales rep in another visual will further filter the line chart but the title remains the same.