Display all values if one date is selected

[#1]

Hi,

i have a little problem with line chart. I want it to display values for the period if the period is selected, but when a certain date is selected - i want it to display all values, ignoring any date selections.

Can anybody help?

Thanks in advance

[#2]

See the attached file.

I hope this is what you want.

I made only a couple of settings.

On general tab of the line chart, "GetSelectedCount(Date)<>0" means more than one value is needed to be selected in the list box of Date field to show this graph.

On expression tab, "Sum({1} Sales)" means this chart always shows all the data regardless of the selections in list boxes.

[jagan]

Hi,

Try like this

=If(Only(DateDimensionName) = '1/1/2014', Sum({<DateDimensionName=>}MeasureName), Sum(MeasureName))

Replace DateDimensionName with your date field, MeasureName with you measure and replace 1/1/2014 with your date.

Regards,

Jagan.

[#4 · Accepted solution]

You could just use this in your expression:

if(GetSelectedCount(Date)>1,sum(Sales),sum({1}Sales))

[SunilChauhan]

sum({1}sales) will block all you selection

please see the attched file

hope this helps