Waterfall chart with two measures

[Anonymous]

My requirement is to add two measures like the below screen shot.

The one circle in blue is a measure which is sales Target and another measure circled in red is Total Price distributed by Stage (Closed, Proposal Delivered,..)

I tried many visualizations but no luck and the closest was the below waterfall chart in which Blue bar is Sales Price as expected but the green Bars are also Sales Target. I tried all the combinations but didnt get the required solution.

Could someone please let me known your suggestion please. 

[v-yangliu-msft]

Hi  @Anonymous ,

After research, I didn’t find any similar visual objects. Here is another way. You can check if you can:

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
var _row=ROW("Stage","Total","SalesTarget",MAX('Table'[SalesTarget]),"TotalPrice",1)
return
UNION('Table',_row)

2. Select the [Stage] column, Column tools – Sort by column – Sales Target.

3. View the image below

4. Select Y axis and close show total.

5. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Hello Liu,

Thank you for your time and helping me on this, let me implement and review this with the customer.

Regards,

Babulal

[parry2k]

@Anonymous how your sample data look like? It will help to provide the solution. Paste sample data in the table format.

[Anonymous]

@parry2k , here is the sample data.

SalesTarget will be median instead of Sum. 

Stage	TotalPrice	SalesTarget
01 Initial Info Exchange -> Survey Sent	123550	500000
01 New Buz Need Identified -> 1st Meeting with Stakeholder	5412111	500000
02 Diligence Meeting in Progress -> Proposal Created	763400	500000
02 Survey Rcvd -> Proposal Created	5433411	500000
03 Proposal Delivered	90899	500000
04 Closed-Won	541000	500000
04 Contract Delivered	433100	500000
05 Contract Signed	23500	500000