Forum Discussion

donodackal's avatar
donodackal
Helper I
4 years ago

Dynamic Title for visuals based on selections

Hello,

 

Can I get help in creating a measure to generate a dynamic label for the below visual "Trend on Spend and Hours Billed By"?

 

I would like the title to change if:

- if the user filters (using slicer) by a directorate, then it says "Trend on Spend and Hours by *filtered directorate* "

- or if the user filters by selecting multiple directorates (using slicer), then it says "Trend on Spend and Hours for selected Directorates"

- or If the user did not filter (using slicer) but selects on any of the directorates from the second visual, the title changes to "Trend on Spend and Hours by *filtered directorate* "

- and if no selection or filter then it says "Trend on Spend and Hours for all Directorates"

 

Thank you in advance. 🙂 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    donodackal ,

    Measure =

    Var _cnt = count(allselected(directorate), directorate[directorate])

    return

    if(_cnt = 1, "Trend on Spend and Hours by" & selectedvalue(directorate[directorate]) , "Trend on Spend and Hours for selected Directorates")

     

    Trend on Spend and Hours by

     

     

    or

     

     

    Measure =

    Var _cnt = count(allselected(directorate), directorate[directorate])

    return

    if(_cnt = 1, "Trend on Spend and Hours by" & selectedvalue(directorate[directorate]) , "Trend on Spend and Hours for selected Directorates" & concatenatex(distinct(directorate), [directorate]) )