topic Re: undefined in Developer

undefined

MonicaNaidu — Wed, 18 Sep 2024 07:25:14 GMT

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

Re: undefined

lbendlin — Wed, 18 Sep 2024 13:15:56 GMT

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

Re: undefined

Anonymous — Thu, 19 Sep 2024 03:18:29 GMT

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