Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
85 | |
73 | |
73 | |
57 | |
51 |
User | Count |
---|---|
44 | |
41 | |
35 | |
34 | |
30 |