Water Fall like that

[MTrullàs]

Hello,

My final objective it's got a graphic like that. The posibilities of the waterfall visual from PBI don't give me all the requests.

So, I try to do through excel to explain my proposal.

I have a dataset like that:

Fgstnr	STATUS
vxz	B
vji	B
fdf	B
fsr	B
ghf	C
uiu	C
iyr	D
kjh	D
yuk	D
oiu	E

If the status A is the sum of the rest of the status, I can get that table:

VALOR	CATEGORIA
10	A
4	B
2	C
3	D
1	E

So, finally I need a measure to get a table like that and the graphic.

I share the set of data, and the excel to describe the process.

https://drive.google.com/drive/folders/1uoBKZ0sXVEPV-Q0sQTflfLzfnIURP3xv?usp=share_link

Thank you very much for your time!

[barritown · Accepted solution]

Hello @MTrullàs, 

Here is my proposal on how to solve your problem.

Step 1. We create a new table with statuses to add an "A" and link it with the existing one.

Step 2. We create 4 x 2 = 8 measures like these:

Step 3. We put them in the right order and adjust the color scheme.

Voila:

Here is the PBIX with this solution - https://www.dropbox.com/s/apyam106gi5z0id/pbi-custom-waterfall.pbix?dl=0

If it is vitally important that the color of the A column matches the color of the "active" segments in all other columns, the measures must be tweaked and become more complicated.