Meausre help for Dynamic title

[vjnvinod]

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

[Anonymous]

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]

@Anonymous 

i have muliple coloumns as slicer(7 slicer)

will this still work ?

[PaulDBrown]

@vjnvinod 

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

[vjnvinod]

@PaulDBrown 

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

[BobBI]

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