Forum Discussion
Water Fall like that
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!
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.
1 Reply
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.