Waterfall Chart current vs last year

[hylosko]

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 ?

[hylosko]

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

[ALLUREAN]

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]

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 ?