Display measure only when no selection made

[deniscamh]

Hello all,

I have a combo chart the represents number of donors and renewal rate by fiscal year.

The renewal rate calculation is: Current Year Active Donors / Total Donors from Prior Year.

When Total Donors from Prior Year is a hard coded field I created in script.

What I need is when there is no selection made by user the chart will display Number of Donors and Renewal Rate but when at least one selection made the chart would display Number of Donors only without Renewal Rate

Please any suggestions?

Before selection

After Selection made

Thanks

[mato32188 · Accepted solution]

Hi Denis,

try this:

Expression:

if(count(GetCurrentSelections()>0), YOUREXPRESSIONwhenSelectionIsMade, YOUREXPRESSIONwhenNoSelectionIsMade)

YOUREXPRESSION should be 0 and then just do not show zero values.

It is dirty solution, but it should work.

BR

Martin

[deniscamh]

Thanks Martin,

That works