Expression-based (dynamic) titles in slicers do not work
Simple setup: Two column, two row table:
and a measure:
Drop a slicer on Column1 into the report. Drop a card with the result of "Measure." Drop a column chart with Column1 as axis and Column2 as values. Then set the column chart's title (using the fx option) to "Measure." Do the same for the slicer's header title, and even the main title. Here's the result:
"Measure" is evaluating as expected in this situation ("A is selected"), and the column chart's expression-based title is behaving as expected as well. But neither the slicer's header title nor its main title reflect the same evaluation. No matter which options in the slicer are selected, the title always remains "Multiple selections".
2 Comments
In further investigation, it appears that one slicer's title will dynamically react to another slicer's selection. It's just that the evaluation of a measure based on a slicer's own value won't change its own title -- it seems the evaluation operation isn't reflexive.
And then, when "A" is also selected in the second slicer, the original slicer's title will change:
v-chuncz-msftCommunity Support
Anonymous
This is by design.
The source visual doesn't filter itself, it filters other visuals (target visuals).