You can just add a filter on the Category in the chart.

I'd suggest you look up "data regions" in SSRS to help you understand the scope of filters and what...

Cool. Forgot to mention, just be aware if your data is at day level using DATEADD(YEAR,-1,GETDATE()) will be giving you data in a window of 08/11/2012 - 07/11/2013...

I assume you are grouping on something like just the numerical month (i.e. 11, 10, 9 ... 12, 11) in the chart? If there is nothing to make it...

Is the chart grouping both Novembers together and giving you 93?

Have you verified that the chart figures you see for last November are not infact for this November? I'm wondering that if you are not grouping on Years &...

Surely you can just use the Iif function in the calculated member since member caption is a text value.

I.e.

WITH

MEMBER [Measures].[ParameterCaption] AS

Iif([Geography].[State-Province].CurrentMember.Member_Caption =...

You can use the Join function in an expression to create a delimited list.

E.g.

=Join(Parameters!Country.Value,",")

Would create a CSV string of the selected countries.

Hi,

These adjustments can be best controlled by using Rectangles. Rectangles can lock adjacent items in place so when they expand they don't push the other one down.

If it is...

You could set DelayValidation = True.

Of course it wouldn't warn you of any other issues until execution...

You can use the Tail function.

e.g.

SELECT

NON EMPTY { [Measures].[Order Count] } ON COLUMNS,

TAIL( [Sales Territory].[Sales Territory Region].Children,3) ON ROWS

FROM

[Adventure Works]

CELL PROPERTIES...

Hi Michele,

I'm actually doing something very similar currently. My code wasn't as nice though.

What I did was to add my Palette table as a dataset then used a Lookup...

+1 😀

Hi, I think what you are interested in is Cascading Parameters. There are plenty of articles to look up.

The only issue you may run up against is that they...

Not necessarily. It was originally stated he was using dataset Filters rather then a clause to filter the query itself.

There are reasons to use a dataset filter over a...

You could use and expression for a filter and evaluate it as a boolean.

E.g.

Set Expression to:

=Parameters!Species.Value = "All" OR Fields!Species.Value = Parameters!Species.Value

Set the type as 'boolean'

Operator as '='

Value as true