Line Graph for Decreasing Values

Question

Hi All,&nbsp;I'm working on a powerBI stuff and looking to find a measure on how I can best do this in Power BI.&nbsp;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?&nbsp;Month&nbsp; &nbsp; &nbsp; &nbsp; Lost Sales&nbsp; &nbsp; &nbsp; &nbsp;Cumulative Sales&nbsp;Sep&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;490Oct&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;480Nov&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;471Dec&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 462&nbsp;Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 454Feb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 447Mar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 440&nbsp;Total Sales 500

v-eachen-msft · Answer

Hi&nbsp;norken20&nbsp;,&nbsp;
&nbsp;
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.
&nbsp;

norken20 · Answer

Thanks&nbsp;v-eachen-msft. Yes your solution is correct.&nbsp;Follow up questions is what if the scenario is like this....&nbsp;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.&nbsp;Thanks!&nbsp;

Forum Discussion

Line Graph for Decreasing Values

2 Replies

Related content

Creating Cumulative Graphs

Count vs displaying value in graph

INQUIRY: Powerquery Decreasing Value

value in graph

How to assign a value to blank values in a graph