undefined

[MonicaNaidu]

Hi 

I am facing issue with dynamic title 

I have an 3 level slicers with different leader levels

If i select leader A in level 1, title should show "dashboard for A"

Similarly if i select another leader X who is reporting to leader A under level 2, title should now show me " dashboard for X"

Basically title should change values dynamically based on latest selection of slicer

I used isfilter and selectedvalue in the measure but even though I selected someone on level2 it still gives me level 1 selection in the title 

To get the the level 2 selection appear on the title I need to unselct all in level 1 which is not my need

Any help or suggestions pls

[Anonymous · Accepted solution]

Thanks for the reply from lbendlin , please allow me to provide another insight: 
Hi  @MonicaNaidu ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
IF(
    HASONEVALUE('Table'[leader level3]),"dashboard for"&" "&SELECTEDVALUE('Table'[leader level3]),
    IF(
        HASONEVALUE('Table'[leader level2]),"dashboard for"&" "&SELECTEDVALUE('Table'[leader level2]),
        IF(
            HASONEVALUE('Table'[leader level1]),"dashboard for"&" "&SELECTEDVALUE('Table'[leader level1]),"Title")))

2. Title – fx.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

How are you planning to enforce single selection in a hierarchy slicer?