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

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'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