Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dynamic title for field parameter

Reporter = { ("Export Country/Territory", NAMEOF('DMT_GTA W_DMT_GTA_V_GTA_FCST_TON'[Export Country/Territory]), 0), ("Import Country/Territory", NAMEOF('DMT_GTA W_DMT_GTA_V_GTA_FCST_TON'[Import Cou...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Kedar_Pande's avatar
    Kedar_Pande
    2 years ago

    Anonymous 

    In Dyamic Title logic use column 'Parameter Order' from parameter table instead of the 'Parameter' column to get away with composite key issue.

     

    💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
    Cheers,
    Kedar
    Connect on LinkedIn

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi Anonymous -you'll need to use a measure that can detect the selected field in your parameter and then display a title accordingly.

 

Create a new measure for the title as below:using the above script and modified as 

Dynamic Title =
SWITCH(
TRUE(),
SELECTEDVALUE(Reporter[Reporter]) = "Export Country/Territory",
"Selected Export Country: " & SELECTEDVALUE('DMT_GTA W_DMT_GTA_V_GTA_FCST_TON'[Export Country/Territory]),
SELECTEDVALUE(Reporter[Reporter]) = "Import Country/Territory",
"Selected Import Country: " & SELECTEDVALUE('DMT_GTA W_DMT_GTA_V_GTA_FCST_TON'[Import Country/Territory]),
SELECTEDVALUE(Reporter[Reporter]) = "Export Zone",
"Selected Export Zone: " & SELECTEDVALUE('DMT_GTA W_DMT_GTA_V_GTA_FCST_TON'[Export Zone]),
SELECTEDVALUE(Reporter[Reporter]) = "Import Zone",
"Selected Import Zone: " & SELECTEDVALUE('DMT_GTA W_DMT_GTA_V_GTA_FCST_TON'[Import Zone]),
"Select an Option"
)

 

 

 

 

I hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

     

    • rajendraongole1's avatar
      rajendraongole1
      Icon for Super User rankSuper User
      2 years ago

      try below:

       

      Dynamic Title =
      IF(
      HASONEVALUE(Reporter[Reporter]),
      IF(VALUES(Reporter[Reporter]) = "Export Country/Territory",
      "Selected Export Country: " & SELECTEDVALUE('DMT_GTA W_DMT_GTA_V_GTA_FCST_TON'[Export Country/Territory]),
      IF(VALUES(Reporter[Reporter]) = "Import Country/Territory",
      "Selected Import Country: " & SELECTEDVALUE('DMT_GTA W_DMT_GTA_V_GTA_FCST_TON'[Import Country/Territory]),
      IF(VALUES(Reporter[Reporter]) = "Export Zone",
      "Selected Export Zone: " & SELECTEDVALUE('DMT_GTA W_DMT_GTA_V_GTA_FCST_TON'[Export Zone]),
      IF(VALUES(Reporter[Reporter]) = "Import Zone",
      "Selected Import Zone: " & SELECTEDVALUE('DMT_GTA W_DMT_GTA_V_GTA_FCST_TON'[Import Zone]),
      "Select an Option"
      )))),
      "Select an Option"
      )