Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Column/linechart variance

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, ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks !