Variable in Chart Expression

[gerhardl]

Hi There,

I have a chart where I want users to be able to select the Month's data they want to look at.

I set up a variable called vSelectMonth with value =GetCurrentSelections([Posted Month])

Then in my chart I use this expression:

Sum({$<[Posted Month]={$(=vSelectMonth)}>}[Trans Amount])

But is is not working (retuns zero).

I've tried adding double and single quotes, no luck.

Would be great if someone can assist (or give me a better way of using specific selections in a chart's expression).

Thanks,

Gerhard

[fdelacal]

hi gerhardl trie without '='

see the lines...

Sum({$<[Posted Month]={$(vSelectMonth)}>}[Trans Amount])

hope it helps you

[gerhardl · Accepted solution]

Hi Facundo,

Just figured out to my problem.

When using "GetCurrentSelections", it returns [FIELD NAME] = [Field Selection], so in this case it returned "Posted Date = Dec".

So I changed my Variable to "GetFieldSelections", which then only returns the Month Name, and now the chart works.

Thanks.