help in waterfall model

[sanjanarama]

I want the result in above water fall , each of the catergory is a seperate measure. how can i achive it. I tried google but i was not able to get to this result, anyone can help me?

[SolomonovAnton]

hello 

you should create table with names for axis X (invoice price, RPU, net price etc)

after it create measure like:

SWITCH(SELECTEDVALUE('new table'[name axis x]),
	"invoice price",[invoice price],
	"RPU",[RPU],
	"net price",[net price],
	etc)

or use Calculation groups 

[sanjanarama]

@SolomonovAnton 
I tried above method and im getting as below output

data is here :

Quarter	customer	family	description	Invoice price	RPU	NetPrice	Cost	Margin
2021Q4	New Info	Family one	1234	160.00	-4.33333	155.6667	8	150.6667
2021Q4	New Info	Family one	1234	164.00	-10	154	10	134
2022Q1	New Info	Family one	1234	160.00	-9	151	35	111
2022Q1	New Info	Family one	1234	164.00	-58.0467	105.9533	42	100.9533
2022Q2	New Info	Family one	1234	160.00	-8.62993	151.3701	18	151.3701
2022Q2	New Info	Family one	1234	164.00	-5.97458	158.0254	14	100.0254

My Sort order table:

My measure for values in waterfall chart:

Bridge = SWITCH(SELECTEDVALUE(SequenceTable[Sort]),

    1,[InvoicePrice],

    2,[RPUa],

    3,[NetPriceA]

)

My model output:

[v-xiaotang]

Hi @sanjanarama 

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

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