Pie chart in SSRS

Question

I have a report with 2 pie charts, giving sales data for product groups. Running a dataset from an OLAP cube.

I want to be able to select 2 different dates for each chart. Example; Someone wants to compare November sales to the previous month. So one chart to display October, one to display November. Or they might want to see how Jan/Feb/Mar compare to Apr/May/Jun.

Can this be done from the same dataset, or do I need to point each chart to a separate dataset?

Answer 1

If the dataset returns the data for both months, you could add filters to each chart to show the appropriate one. However, it sounds like you'd want this to be more dynamic.

I would suggest creating two separate datasets, each with a month parameter. This will allow the user to select any combination of two months. The charts would simply point to their respective dataset. You shouldn't incur a noticeable performance hit either way.