How to create Water Fall Charts

[Anonymous]

Hi All,

I Created 3 measures. I need to implement Water fall chart.

previous month Head count=Count({<CDate = {'05/01/2016'}>}DISTINCT([Head_Count.Emp. Id])) 

Current Month New hires count=count({<Newhires.CDate_NH={'>=06/01/2016'}>}[Newhires.Emp. Id])

Current month Exit count=Count({<CDate = {'06/01/2016'}>}DISTINCT([Head_Count.Emp. Id]))

Current month Head count=

      (previous month Head count+Current Month New hires count-Current month Exit count)

1st Bar : previous month Head count

2nd Bar : Current Month New hires count

3rd Bar : Current month Exit count

4th Bar : Current month Head count

Please help me.

Thanks,

Kalyan Krishna

[sunny_talwar · Accepted solution]

You want something like this Kalyan?

[Clever_Anjos]

Something like  this?

[Anonymous]

Thanks Sunny

[Anonymous]

Thanks Clever Anjos

[sunny_talwar]

No problem at all