Forum Discussion

tjhoolahan's avatar
tjhoolahan
Icon for Helper I rankHelper I
6 years ago

Waterfall chart query - show absolute numbers

Hi,   I am looking to build a waterfall chart in Power BI that shows the total number of clients each month, with a breakdown of the specific number of new, recovered and lost clients that occurred...
Need Help
tjhoolahan's avatar
tjhoolahan
Icon for Helper I rankHelper I
6 years ago

amitchandak hope this works for you?

 

Status          Date                       Client Numbers

Total01 January 202010000
New01 January 202050
Lost01 January 2020-75
Recovered01 January 202015
Total01 February 20209990
New01 February 202053
Lost01 February 2020-40
Recovered01 February 202021
Total01 March 202010024
New01 March 202060
Lost01 March 2020-80
Recovered01 March 202010
Total01 April 202010014
  • tjhoolahan's avatar
    tjhoolahan
    Icon for Helper I rankHelper I
    6 years ago

    @amitchandak, did you have a chance to test with the sample data I provided?

    Best,

    Tim