cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Re: Display difference in clustered column chart

With this data set, how is your measure look like? I want to divide population in 2000 by 2014 @Anonymous

Highlighted
Anonymous
Not applicable

Re: Display difference in clustered column chart

@s15

 

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. 

 

Population growth.png

View solution in original post

Highlighted
Helper III
Helper III

Re: Display difference in clustered column chart

Can I have the "20%" display somewhere on the chart?

Highlighted
Anonymous
Not applicable

Re: Display difference in clustered column 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.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors