Forum Discussion

MTrullàs's avatar
MTrullàs
Helper III
3 years ago
Solved

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....
Need Help
  • barritown's avatar
    barritown
    3 years ago

    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.

barritown's avatar
barritown
Solution Sage
3 years ago

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.