Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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)   ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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