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]) &" "&SE...
Need Help
Show and Tell
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 ?