Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Stacking Accumulated Values, Legend Split by Year in a Line Graph

Hi - slightly tearing myself apart over this one - feels like i'm so close.   Basically, I have the following table:   id value year AsOfDate 1 45.34 2020 31 December 2020 2 44.10...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , based on what I got, If need overlapping you need measures not legend and you will not get year wise label. Also Always use date table for time intelligence

 

PnL = calculate(sum(DailyPnl[Value]), DATESYTD(Date[Date],"31/12"))

PnL LY= calculate(sum(DailyPnl[Value]), DATESYTD(dateadd(Date[Date],-1,year),"31/12"))

PnL LLY= calculate(sum(DailyPnl[Value]), DATESYTD(dateadd(Date[Date],-2,year),"31/12"))

PnL L2LY= calculate(sum(DailyPnl[Value]), DATESYTD(dateadd(Date[Date],-3,year),"31/12"))

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.