Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Year over Year calculation Issue

 I'm trying to show the variance year over year on the graph. Here's my time table and a column I added to indicate the year status   Here're my measures CYSpend = CALCULATE([Total Spend], ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous

     

    The issue here is that the legends (FY) you have used is slicing the value in your measure delta.

     

    When you use the measure delta v/s months, their is no need of legend as you have already defined the logic as difference between Total spend of current and previous year.

     

    If you also want to display the individual values whose delta is being calculated, pull in the measures CY Spend and PY Spend in the line chart. This should solve your issue.

     

     

    Thanks,

    Suguna.

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

Please try to update the measure as below. If it doesn't meet your requirement, kindly share your pbix to me.

 

delta = IF(ISBLANK([PYSpend]),BLANK(),[CYSpend] - [PYSpend])

Regards,

Frank