Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Expression-based (dynamic) titles in slicers do not work

Simple setup:  Two column, two row table:

andrewbrick_0-1628562556723.png

and a measure:

Measure = if(selectedvalue('Table'[Column1])="A","A is selected",if(selectedvalue('Table'[Column1])="B","B is selected","Multiple Selections"))

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:

andrewbrick_2-1628562951638.png

 

"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". 

Status: New
Comments
andrewbrick
Advocate IV

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.

andrewbrick_0-1628563549331.png

And then, when "A" is also selected in the second slicer, the original slicer's title will change:

andrewbrick_1-1628563589317.png

 

v-chuncz-msft
Community Support

@andrewbrick 

 

This is by design.

The source visual doesn't filter itself, it filters other visuals (target visuals).

https://community.powerbi.com/t5/Issues/Field-Conditional-formatting-is-not-working-in-slicer/idi-p/...