Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful 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
BobBI's avatar
BobBI
Resolver 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