Forum Discussion
Helper IIIDisplay 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.
Helper IIIJust typo. You don't have to worry about the year. It is my typo. I just want to display the growth rate in clustered chart.
If you have this data structure:
Year Population Country
2000 10000000 Canada
2014 20000000 Canada
You can use this visual: Line & Clustered column chart. Then just plot the according values.
s15 Did we solve your problem?
- s15
No it is not. Could you please show your screenshot? The chart that Eric_Zhang is very hard to understand.
Thank you.
- s15
With this data set, how is your measure look like? I want to divide population in 2000 by 2014 Anonymous
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.