Forum Discussion

Cathryn's avatar
Cathryn
Helper III
8 years ago
Solved

dynamic title based on grid row selection

Hi All

 

Does anyone know how to create a  dynamic header based on a selection within a grid?  I know how to do it with slicers but it's not working when just selecting within a grid.

 

I've tried:

TCodeHeader = var tCodeSelected = SELECTEDVALUE('BI T-Code by Industry'[SAPTCode]) return "TCode: " & IF(ISBLANK(tCodeSelected), "All T-Codes", tCodeSelected)

 

and 

TCodeHeader = IF(OR(isFILTERed('BI T-Code by Industry'[SAPTCode]), isFILTERed('BI CONNECT Usage'[SAPTCode])) ,VALUES('BI T-Code by Industry'[SAPTCode]), "TCode not selected")

 

and 

 

TCodeHeader = IF(DISTINCTCOUNT('BI T-Code by Industry'[SAPTCode])=1 ,VALUES('BI T-Code by Industry'[SAPTCode]), "TCode not selected")

 

Maybe it's not possible yet?


Cathryn

 

Need Help
  • Cathryn's avatar
    Cathryn
    8 years ago

    I figured it out.   I was creating a column vs a measure.  A dynamic title won't work if you create a column with code I mentioned above.  It needs to be a measure just in case anyone else has the same issue.

1 Reply

  • Cathryn's avatar
    Cathryn
    Helper III
    8 years ago

    I figured it out.   I was creating a column vs a measure.  A dynamic title won't work if you create a column with code I mentioned above.  It needs to be a measure just in case anyone else has the same issue.