I need help to Create Water flow chart

[Anonymous]

I need some help regarding Water flow chart   i have 5 measures ,  how to use water flow chart

now i have Chart 1(Clusterd Column Chart) but i expect the result chart 2 (water flow Chart)

[amitchandak]

@Anonymous , refer these

https://community.powerbi.com/t5/Desktop/Waterfall-Chart-using-multiple-measures/td-p/439275/page/2

https://www.decisivedata.net/blog/power-bi-waterfall-chart-showing-dynamic-user-input

[Anonymous]

@amitchandak    i have created another one table then i can use the Measure in this new table but it's showing error

Column = SWITCH(FIRSTNONBLANK('Table'[Measure],'Table'[Measure]),"Plan",CALCULATE(SUM('MYCCT-Main'[Plan-YTD]),FILTER('MYCCT-Main','MYCCT-Main'[kpi]=="NIBIAT"),0))

Can you Please help me?

[amitchandak]

@Anonymous 

Try like

Column = SWITCH(FIRSTNONBLANK('Table'[Measure],'Table'[Measure]),"Plan",CALCULATE(SUM('MYCCT-Main'[Plan-YTD]),FILTER('MYCCT-Main','MYCCT-Main'[kpi]="NIBIAT")))

[Anonymous]

@amitchandak   it's working now but i need month , year filter this table how to do it,   my previous table have a month , year column but here there's no month year column how to use this

Previous Chart