Stacked Column Chart to simulate a waterfall

[Luis_u534485]

Hi Team,

Can somebody to know how do i need to arrange table/data in pbi to be able to construct something like below image?

Image is from a stacked column in Excel and I'm using the table numbers to fed the graph.   Consider that:

• BUD YTD and CY+1 Plan are compared vs Waterfall
• FY CY Plan is the sum of 1 + the largest value between 2 or 3 (YTG/OOrders)
• And graph changes based on selected product

Sorry and thanks,

, 

[amitchandak]

@Luis_u534485 , Create a Calculation group.

You need to have one or more measures for each stack row (Make sure the Measure in white color should added before )

Now go to the calculation group table and add a column that will group measures to appear on each row of  stacked  and then use that group and calculation group as the Axis in the visual

	Add Manually
Calculation Item	Group	Color in Visual	Measure copied in step
Measure 1	Budytd/ytg
Measure 2	Budytd/ytg		Meausre 2
Measure 3	ACTKS	White
Measure 4	ACTKS
Measure 5	YTDKS	White	Measure 4
Measure 6	YTDKS
Measure 7	OOrdersKS
Measure 8	OOrdersKS
Measure 9	FY CY KS
Measure 10	CY Plan KS