SSRS Chart to group by months based on fiscal year instead of calendar year

Question

I've created a SSRS chart to group by months. I'm able to get the months to be displayed on the chart based on fiscal year (starting in October and end in September). However, the counts & values are still based on calendar year. How do I get the SSRS bar chart to group based on fiscal year?

For example.. On the attach print screen, you can see the months is in fiscal year order but it's group by calendar year with the new color (green) on Jan, Feb, March, & April. If it's grouped by fiscal year, Oct, Nov & Dec should also be in green.

Anybody have any ideas how I can set my SSRS chart to group by fiscal year?

Please Help! Thanks!

Chart showing correct month order but group by calendar year

Here's an example of my data. Example of Data

Chart setting with the expression I use for grouping

Answer 1

I've actually found the answer. On my series Group, I grouped the receivedon.Value date by Year but if the receivedon.Value month is Oct, Nov or Dec, add 1 year to the receivedon.Value date.

=iif(Month(Fields!receivedon.Value)10,Year(Fields!receivedon.Value),Year(DateAdd(DateInterval.Year,1, Fields!receivedon.Value))))