cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Post Prodigy

## waterflow chart with calculation

Hi,

I want to make a very difficult waterfall chart from the following table:

 Name Type1 Type2 Type3 S C D A TBD a1 A # P 1 1 a2 B # P 1 1 a3 C # B 1 1 a4 # Y N 1 1 1 a5 # Y N 1 1 1 a6 A # N 1 1 a7 # Y N 1 1 1 a8 B # P 1 1 a9 A # P 1 1 a10 A # N 1 1 a11 # Y O 1 1 a12 # # O 1 a13 # Y N 1 1 1 a14 B # P 1 1 a15 # Y O 1 1 a16 A # P 1 1 1 a17 A # P 1 1 1 a18 # Y N 1 1 1 a19 B # P 1 1 a20 C # N 1

I consider the count of each row and the result is:

 S C D A TBD Count 16 7 4 16 2

And I want to make the following chart:

The waterfall chart has 8 steps. It starts and ends with S column. Green is  count of C column, red is shown as decrease. Purpol (A column) doesn't have any relationship with the previous ones. It is just reflection of count of column A.  Second red column is TBD column and it is decrease. Blue column is a calculation column, based on A-TBD result, which is X. Yellow (Y value) is X-S. At the end S column is repeated.

I hope I can find a solution for this.

All the best

Super User

I think you are talking about two separate waterfall charts.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

#### Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors