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.
View solution in original post
Can I have the "20%" display somewhere on the chart?
You can drag the card visual on top of the clustered bar chart and then push it to front. But, to my knowledfe, there isn't the type of integration, which you are asking for.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.