Forum Discussion

hylosko's avatar
hylosko
Icon for Helper III rankHelper III
4 years ago

Waterfall Chart current vs last year

Hi PBI experts !

 

I need to build waterfall like in picture:

 

I have 3 columns in 3 diffrent tables:

in [Table 1] i have column [Category]

In [Table 2] i have column [Values]  which is measure

In [Table 3] i have column Y-M-D 

and it looks like 

 

Any ideas how can i build my waterfall ?

 

Need Help

3 Replies

  • hylosko's avatar
    hylosko
    Icon for Helper III rankHelper III
    4 years ago

    In this waterfall i want to compare current January vs January 2021

    • ALLUREAN's avatar
      ALLUREAN
      Icon for Solution Sage rankSolution Sage
      4 years ago

      Hi, hylosko 

      There is different ways to achieve this and if you use slicer to select between two months or you need fixed current year (2022) and last year will be 1 year back.

       

      Some example is below, you just need to create Year-Month combination and use it on X-Axis.

      • hylosko's avatar
        hylosko
        Icon for Helper III rankHelper III
        4 years ago

        Yes that help :),  now i have sth like this :

         

         

        -on the left visual  in Category:[Category Column], Values:[Values]

        -on the right visual same like in ALLUREAN solution

         

        There is some method to combine these two visualizations in one ?