Insert multiple rows with some blank and some computed columns till some date to show trend line

Question

Hello,&nbsp;In my current example, I am holding data for let's say till 7th of May. However, there is some future date decided to forecast the trend line, suppose 8th of August. Now, how do I insert such rows(number of rows to be inserted would be in days for 8th of Aug minus 7th of May) in the dataset with some blank columns and some columns that would be computed based upon a formula.&nbsp;&nbsp;Currently, PBI only shows up the data that it can fetch but nothing to show as a trend line.&nbsp;Please help.&nbsp;Thanks,Nitin

amitchandak · Answer

Anonymous ,Not very clear to me. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

anonymous · Answer

sample:901&nbsp; &nbsp; 740&nbsp; &nbsp; 571&nbsp; &nbsp; &nbsp; 662&nbsp; &nbsp; 5/5/2021903&nbsp; &nbsp; 737&nbsp; &nbsp; 564&nbsp; &nbsp; &nbsp; 659&nbsp; &nbsp; 5/6/2021903&nbsp; &nbsp; 737&nbsp; &nbsp; 558&nbsp; &nbsp; &nbsp; 659&nbsp; &nbsp; 5/7/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 552&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5/8/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 545&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5/9/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 539&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5/10/2021PBI draws till date 5/7/2021 where it finds all the date from the subsequent row. However, I want to draw till 5/10/2021 in a line chart.

anonymous · Answer

Intended sample picture:&nbsp;While PBI drawn picture:&nbsp;As you can see the black line is not extended just like in the first figure.

anonymous · Answer

Reason for this is that all column values are available only for rows till 5/7/2021. Rest of the values are not availble. Hence, how could I achieve this as intended in the figure and sample data shown above.&nbsp;

anonymous · Answer

Any help regarding this would be greatful.&nbsp;Thanks.

Forum Discussion

Insert multiple rows with some blank and some computed columns till some date to show trend line

9 Replies

Related content

Sequential Order column based on multiple criteria

Multiple line and clustered columns chart

Workspace Monitoring - compute costs ?

Your Compute session is disconnected

Summarize Multiple Columns