waterfall chart with multiple calculations from two tables.

[Anonymous]

I am currently facing a challange in creating the desired water fall chart model. 

Scenario: Each of these categorizations are different measures from two tables.

I was thinking of coming at this problem in in two ways.

One, by adding multiple measures into Waterfall chart, which is not possible as the chart accepts only one measure or column. Please let me know if I am wrong in this.

Second, by creating these 13 measures in a single column by having 13 rows with their own formule. I know this sounds dumb, but i am thinking out options to create this.

Data relating to this is looks like the below table:

Type	Plan Qty (t)	Plan Rev A$K	Plan A$/t		Actual Qty (t)	Actual Revenue A$K	Actual A$/t		Delta Qty (t)	Delta Revenue A$K	Delta A$/t		Volume Variance A$K	Price Variance A$K	Total Variance A$K
Dom HD	1069	1951	182		565	5544	2397		-1093	3498	572		-2338	5837	3498
Dom LD	345	663	192		376	8844	2814		-76	2861	891		-147	3007	2861
Dom LLD	684	1334	195		233	9987	2508		184	4277	558		359	3918	4277
Dom PE	3098	3949	188		2225	1122	2506		-985	10636	624		-2126	12762	10636
Exp HD	255	411	168		170	4567	2032		-818	-577	424		-1293	716	-577
Exp LD	750	419	167		681	7654	2602		-1864	-2529	926		-3123	594	-2529
Exp LLD	112	215	191		951	3345	2578		-161	324	659		-309	633	324
Exp PE	918	1046	169		331	2245	2298		-2223	-2782	606		-4725	1943	-2782
Total PE	27174	49961	1839		23346	5788	2476		-3828	7854	638		-6851	14705	7854

The blue highlighted figures are the x-axis measures that are represented.  

Thanks in advance for the help

[v-zhangti]

Hi, @Anonymous 

The following is a hint of the waterfall chart, and it is not feasible to put 13 measures as you expect.

For the second method, you can refer to the following link, hoping to help you.

Solved: Put multiple measures in one table for waterfall c... - Microsoft Power BI Community

Solved: Waterfall chart with multiple measures - Microsoft Power BI Community

Solved: Bridge/Waterfall chart with multiple values - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

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

[Anonymous]

Hi @v-zhangti  Thanks for the links. They helped me figure out my issue. I have an issue when we start to apply the measures in waterfall chart. 

So,

 Step 1: I created a single column containing the names of all the measures in a new table, and wrote a measure linking the names to the actual measure. The waterfall chart that appears is attached below. 

However, I would like the waterfall chart to compare Plan Revenue(on the left most column) against Actual Revenue (on the right most column) like below:

This will give me the journey of where my costings went.

Is there a way to order them and make sure that Plan revenue (from first image) starts from 0 rather than 67k?