Graph - Quarters - Actual, Budget, PriorYear

[#1]

I was requested to create a graph which shows the Actual, Budget AND PRIOR YEAR figures for the last 8 quarters.

As I have a time axis in the diagramm (quarters) I do not have an idea how to include the Prior Year figures.

Example:

The 1.Quarter 2011 should be the last in the graph, so the first one should be Q2 2009, Q1 2011 should have one bar for the Actuals, one for the Budget and one with the figures of Q1 2010 !!

Hope it is not too hard to solve and that you smart guys here are able to help me 😃

Regards,
Christoph

[#2]

no one has an idea? =(

[#3]

Hi Christoph,

you can include your prior year bar with this expression :

Budget of your actual year :

sum({<[Year]={"$(=max([Year]))"}>}[Budget])

Budget of your prior year :

sum({<[Year]={"$(=max([Year]-1))"}>}[Budget])

That's what you want?

Regards,

Mickaël.