Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Waterfall week over week

Hi,

 

We have a snapshot opportunity table, taking a snapshots every day. This way, we can see the Value of all our opportunities every day and how it develop.

 

It is possible to do a week over week waterfall, something like this?..

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi! 

       

      Thanks a lot! This get's me quite far!

       

      However, I have yet another request that I was hoping you might be able to help me with.

       

      If you imagine a Pipeline table with Deals and Status, we would like to see, based on start and end selection the following waterfall splits:

       

      Start Date - Show "Open" deal value

       

      Then with waterfalls:

       

      "Deal size Won"

      "Deal size Lost" 

      "Change in dealsize"

      "Size of New Added Deals"

       

      So something like this: 

       

       

      Where I would believe an output like this:

      thanks! 

       

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi, Anonymous 

        Thank you for your feedback.

        Sorry to say that I quite do not understand your last question.

        I cannot match your table with the visual in the last question.

        If it is OK with you, please share your sample pbix file, then I can try to look into it to come up with an accurate solution.

        Thanks.