Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Display Previous year data with year as dimension


I would like to create a Bar Chart with  dimension Year  and a measure showing the previous year  sum of  [Value]  meaning  sum({ previous year} [Value])

for example I expect to see for 2019 bar the sum for 2018, for 2018 bar the sum for  2017 and so on. 

I tried many options, but it doesn't work well.
the same worked for me before with other dimensions.

how can this be done? 


*I actually need to display the change percentage between the year and the year before,   i was trying to simplify the issue.   


Thank you!


Labels (1)
10 Replies
Partner - Master
Partner - Master

That's right, the expression only shows previous value.

But you can add actual value.

See example


and the value in column 2 in above-expression is december value