Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic Waterfall chart displaying current and previous period

Hi,

I want to create a dynamic waterfall chart filtered via a period slicer.
The waterfall chart needs to display 2 periods - selected period and the previous one. 

The values contribution to the water fall movement are already calculatued..... basically, I have the values in the same structure as in excel for creating waterfall charts.

Is it possible to create the same in powerbi?

Any advice and the knowledge of what is possible in powerbi

 

Need Help

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ，

    Since I don't have your specific data about the dynamic waterfall chart, you can see my template below, the time in the template will change dynamically according to my slicer selection, untwo months of data. You can refer to my template and adjust it to your data.

     

    And you could refer similar question:(se a measure as a filter ）

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Dear Lucien,

      Thanks for responding. I had seen this solution and tried to adopt this template to my data unsuccesuflly....atleatst, I tired.

      Here is the link to data in excel.

      Looking at my file could you please advice if this is possible?

      I am very appreciative of any advise. Thank you and regards SMC_FR