Column/linechart variance

[Anonymous]

Hey

Setup:

Compare revenue of several products. 

Column: Revenue, per year, multiple products

Line: Variance Y-t-Y

Now the problem is that I only get 1 line. If multiple objects selected, it just takes the total variance and not the individual variance per object. 

For example. 3 products, 3 years.

For each year, 3 columns, one per product. 3 lines throughout the chart for the variance. 

Thanks a lot! 

[v-jingzhang · Accepted solution]

Hi @Anonymous 

In this case, you need to create individual measures for different products. For example:

Variance % A = 
VAR thisYear = SELECTEDVALUE('Table'[Year])
VAR thisYearRevenue = CALCULATE(SUM('Table'[Revenue]),ALLEXCEPT('Table','Table'[Year]),'Table'[Product]="A")
VAR lastYearRevenue = CALCULATE(SUM('Table'[Revenue]),ALL('Table'),'Table'[Year]=thisYear-1,'Table'[Product]="A")
RETURN
DIVIDE(thisYearRevenue-lastYearRevenue,lastYearRevenue)

Change the product name in the measure to create multiple measures for multiple lines in the chart. Here is a pbix file for reference.

Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[Anonymous]

Thanks ! 

[parry2k]

@Anonymous Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490