Forum Discussion
I need help to Create Water flow chart
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)
4 Replies
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
Super User
Anonymous
Try like
Column = SWITCH(FIRSTNONBLANK('Table'[Measure],'Table'[Measure]),"Plan",CALCULATE(SUM('MYCCT-Main'[Plan-YTD]),FILTER('MYCCT-Main','MYCCT-Main'[kpi]="NIBIAT")))
