Display difference in clustered column chart

[s15]

Hi all,

I'm finding a way to display difference between two values in my clustered column chat. I have a measure to calculate the difference but don't know how to integrate it to the chart.

[Eric_Zhang]

@s15 wrote:

Hi all,

I'm finding a way to display difference between two values in my clustered column chat. I have a measure to calculate the difference but don't know how to integrate it to the chart.

@s15

What is your difference measure like? You could probably put the measure to the tooltip field.

By the way, for me, I'd use a line chart. See more details in the attached pbix file.

difference =
CALCULATE (
    DIVIDE (
        SUM ( yourTable[Value] )
            - CALCULATE ( SUM ( yourTable[Value] ), SAMEPERIODLASTYEAR ( 'calendar'[Date] ) ),
        SUM ( yourTable[Value] )
    )
)

[s15]

@Eric_Zhang

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.

[Anonymous]

@s15

Can you show us how you've stored your data?

[s15]

@Anonymous

This is very simple like this

[Anonymous]

@s15

But in your plot you have sum of 2013?

Where do you get that from?

[s15]

Just 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.

[Anonymous]

@s15

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]

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

[Anonymous · Accepted solution]

@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. 

[s15]

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

[Anonymous]

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.

[Anonymous]

@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.