Forum Discussion

RemiAnthonise's avatar
RemiAnthonise
Icon for Helper V rankHelper V
7 years ago

Start graphics or visuals later but WITH previous data

Hi guys,

 

I hope you can help me with this issue:

I have a dataset with data < 1-1-2017. I want to display some data in a graphic but starting at 1-1-2017. But I want to include previous data, so kind of a sum including data before 2017. I don't need to see previous years in my graphic but I want to have the data when my graphic starts at 1-1-2017.

See image below. I expect to start on the second image with value +- 4.5k and not from zero. Can you help?

 

Need Help
Show and Tell
Tips and Tricks

6 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi RemiAnthonise

    Do you mean the value for 1-1-2017 should be the previous data before 2017/1/1 instead of 0?

    Could you show me an example of your data?

     

    Best Regards

    Maggie 

    • RemiAnthonise's avatar
      RemiAnthonise
      Icon for Helper V rankHelper V
      7 years ago

      Hi v-juanli-msft

      Here you'll find my sample. Note: the original file is a big file so to download it can take a while.

       

      Below screenshot is from page 1. Page 2 and page 3 have the same problem but I expect that I can handle this of we can solve the problem on page 1.

      All the data in the black box should be summed so the line in the red box starts on 1-1-2017 with approx 1178 as start data,