Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could just use this in your expression:
if(GetSelectedCount(Date)>1,sum(Sales),sum({1}Sales))
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.
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.
You could just use this in your expression:
if(GetSelectedCount(Date)>1,sum(Sales),sum({1}Sales))
sum({1}sales) will block all you selection
please see the attched file
hope this helps