Line Graph for Decreasing Values

[norken20]

Hi All,

I'm working on a powerBI stuff and looking to find a measure on how I can best do this in Power BI.

A line graph showing the decreased values over months. Sample table is below... I want to have the starting point at 500 (Total Sales) and line graph shows the decreasing value (Cumulative Sales). What is the best way to do this?

Month        Lost Sales       Cumulative Sales 

Sep             10                         490

Oct             10                         480

Nov              9                         471

Dec              9                          462 

Jan               8                          454

Feb              7                          447

Mar             7                          440

Total Sales 500

[v-eachen-msft]

Hi @norken20 , 

You could add an index column in the query editor to make data ordered by month. Then set your y-axis end to 500 in the "Y axis" option.

[norken20]

Thanks @v-eachen-msft. Yes your solution is correct.

Follow up questions is what if the scenario is like this....

My table is like this. Assume that Remaining YTD Sales column is not existing. What is the best way to create a graph shown below the table showing the Remaining YTD Sales and the Forecast Sales is not fixed instead it keeps updating every month.

Thanks!