Skip to main content
cancel
Showing results for 
Search instead 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.

Reply
IF
Post Prodigy
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:

24.jpg

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

1 REPLY 1
lbendlin
Super User
Super User

I think you are talking about two separate waterfall charts.

Helpful resources

Announcements
Microsoft Fabric Learn Together

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

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

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