Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago

Meausre help for Dynamic title

hi Expers

 

this is my current measure, for "Title/dashboard Header"

which is not giving me the exact header i would like to see

TItle = SELECTEDVALUE('Pipeline Extract'[AccountSector])
&" "&SELECTEDVALUE('Pipeline Extract'[AccountSubSector])
&" "&SELECTEDVALUE('Pipeline Extract'[ServiceLine],"(Total Pipeline)")
 
See below pic
when i select "Media and entertainment from my slicer it should show
"Media and Entertainment Pipeline dashboard" and so on for other 2 sector as well
and also for any of other slicer i select it should suffix that name with "Pipeline dashboard"
 
Currently the above measure is not working, which i was trying to do by own
 
 
Need Help
Show and Tell

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi vjnvinod ,

     

    please try the below DAX to make dynamic titles.

     

     

    DynamicSelection =
VAR _Count =
    COUNTROWS ( VALUES ( Table_ColumnName ) )
VAR _Concat =
    CONCATENATEX (
        VALUES ( Table_ColumnName ),
        Table_ColumnName,
        ","
    )
RETURN
    IF ( _Count > 4, "Multiple Selection", _Concat + "TOTAL PIPLINE" )

     

     

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.

     

    Regards,

    Gaurav Raj Singh

    LinkedIN : https://www.linkedin.com/in/gauravrajsingh/

    • vjnvinod's avatar
      vjnvinod
      Icon for Impactful Individual rankImpactful Individual
      6 years ago

      Anonymous 

       

      i have muliple coloumns as slicer(7 slicer)

      will this still work ?

  • BobBI's avatar
    BobBI
    Icon for Resolver III rankResolver III
    6 years ago

    Hi Vinod,

     

    try this DAX ,

    I created 3 variable to capture value from each slicer and populate blank if no value selected . concatenate them.

    you can populate some default value if none of the filter is selected.

     

    below dax  show one  selected value from each slicer , This will give you an idea and you can play a trick to match your requirement 🙂

     

     

    Dynamic Title =
    Var Slicer_country = if(HASONEFILTER(eMasterASI[Country]),values(eMasterASI[Country])," ")
    Var Slicer_location = if(HASONEFILTER(eMasterASI[Location]),values(eMasterASI[Location]),"")
    Var Slicer_Ptype = if(HASONEFILTER(eMasterASI[Position Type]),values(eMasterASI[Position Type]),"")

    Return
    Slicer_country&" " & Slicer_location & " " & Slicer_Ptype
     
    hope this would help,
    sukhi
  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    6 years ago

    vjnvinod 

    Are your slicers separate tables? if so, your measure should reference those using their corresponding SELECTEDVALUE

     

    • vjnvinod's avatar
      vjnvinod
      Icon for Impactful Individual rankImpactful Individual
      6 years ago

      PaulDBrown 

       

      they are not separate, its coming from one table (various coloumns)