Forum Discussion
Display difference in clustered column chart
You need year on the axis to achieve what you want, which is why I proposed a new data structure.
My measure looks like this:
Population growth =
(CALCULATE(SUM(test[Population]); test[Year]=2014) / CALCULATE(SUM(test[Population]); test[Year]=2000)) - 1
See picture below. There is 2 types of visualizations. One with clustered bar and another one with clustered chart and trend line. If you hover over the columns, you'll see the population growth.
I just need to display the difference of growth between year 2000 and year 2014. My dataset contains population of Canada in different years. From my example, the growth rate is 13,42% by the measure below
Difference = 1 - (SUM(Population[2000])/SUM(Population[2014]))
Displaying the difference is helpful to explain my data.
I drag and drop my measure into Tooltip but nothing changes.