topic Re: Help - DAX Measure for Dynamic Chart Title with DrillDown in DAX Commands and Tips

Help - DAX Measure for Dynamic Chart Title with DrillDown

bboobe — Sun, 24 May 2020 06:59:52 GMT

Dear Experts,

I am trying to create the below measure but it is not working.

Measure -

Test Chart Title =

Var MonthPart = SELECTEDVALUE('Time Day'[Month_Year],"Current Month")

Var Geography = IF(

ISFILTERED('PS Location'[COUNTRY],

SELECTEDVALUE('PS Location'[COUNTRY]), "" )

return

"Country Wise" & Geography & MonthPart

Geography is not returned in this measure. Please help.

Re: Help - DAX Measure for Dynamic Chart Title with DrillDown

nandukrishnavs — Sun, 24 May 2020 07:47:00 GMT

bboobe

Try this

Test Chart Title = VAR MonthPart = SELECTEDVALUE ( 'Time Day'[Month_Year], "Current Month" ) VAR Geography = IF ( ISFILTERED ( 'PS Location'[COUNTRY] ), SELECTEDVALUE ( 'PS Location'[COUNTRY] ), "" ) RETURN "Country Wise" & Geography & MonthPart

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

Re: Help - DAX Measure for Dynamic Chart Title with DrillDown

bboobe — Sun, 24 May 2020 08:02:52 GMT

nandukrishnavs It Worked!! Awesome, Thanks!