Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to create a dynamic title based on slicer value selection ?

Hi ,

 

I am trying to desgin a Dynamic title for one of the reports . Please help me with below case. 

 

I have 2 slicers like Support Organisation and Director . If I select some value in this 2 slicers I want a Dynamic title to be like : 

 

[Support Organisation] + "Changes For" + [Director] . So i have written a measure like below . However, it is not working. Kindly help 

 

Group Title = IF(OR(ISFILTERED('ALL Director'[Director]),ISFILTERED('ALL Support ORG'[Support_Organization])),SELECTEDVALUE('ALL Support ORG'[Support_Organization]) && " Changes For " && SELECTEDVALUE('ALL Director'[Director]),"No Selection")
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Anonymous ,

     

    Please modify the measure as below:

    Group Title = 
IF (
    OR (
        ISFILTERED ( 'ALL Director'[Director] ),
        ISFILTERED ( 'ALL Support ORG'[Support_Organization] )
    ),
    SELECTEDVALUE ( 'ALL Support ORG'[Support_Organization] ) & " Changes For "
        & SELECTEDVALUE ( 'ALL Director'[Director] ),
    "No Selection"
)

     

    Community Support Team _ Jimmy Tao

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

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Anonymous ,

     

    Please modify the measure as below:

    Group Title = 
IF (
    OR (
        ISFILTERED ( 'ALL Director'[Director] ),
        ISFILTERED ( 'ALL Support ORG'[Support_Organization] )
    ),
    SELECTEDVALUE ( 'ALL Support ORG'[Support_Organization] ) & " Changes For "
        & SELECTEDVALUE ( 'ALL Director'[Director] ),
    "No Selection"
)

     

    Community Support Team _ Jimmy Tao

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