YoY YTD cumulative on line chart

[AndrejZitnay]

Hello guys,

I am trying to show 2017 vs 2018 ytd cumulatives in one line chart.

My measures are correct and I can see correct figures & percentages on table.

Retail Cumulative m/m = [Cumulative YTD RETAIL]/[Cumulative YTD Total]

Cumulative YTD RETAIL = TOTALYTD(SUM(Sheet1[RETAIL.]),MasterCalendar[Date])

Cumulative YTD Total = TOTALYTD(SUM(Sheet1[TOTAL]),MasterCalendar[Date])

Problem is when I am trying to viual this in line chart. 

Tope line chart is how it should look like in excel.

Botom charts are my current outcomes in BI.

Would you be so kind and help me out?

[Anonymous]

Hi @AndrejZitnay,

Can you please share some sample data to test?

Regards,

Xiaoxin Sheng

[AndrejZitnay · Accepted solution]

Hello @Anonymous,

I have manged to reslove this when I was creating exmple for you.

Thanks anyway for offering your help.

Andrej