Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Waterfall Chart for Cycle Time

Hi!

I'm trying to create a waterfall chart or waterfall type view for monthly average cycle time.

 

The data looks like this:

 

I want to have a view where it shows the change between each months average, with a negative change being positive (since we want cycle time to go down).

Example, the starting point would be January (average 55).
For February it would be a green bar (starting at 55) going down to 25 and for March it would be a green bar going down to 7. So showing the variance of monthly average.

 

I'm  not sure if the waterfall visualization can do all of these specifics, suggestions are very appreciated!

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    For Waterfall Chart, I'm afraid it couldn't achieve in Power BI for now.

    As a workaround, you could try adding a conditional formatting for bar chart as below:

    https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

    Add a MOM change measure, for example:

    ispositive = 
	VAR __PREV_MONTH =
		CALCULATE(
			AVERAGE('Table'[Cycle Time]),
			DATEADD('Table'[Completion Date].[Date], -1, MONTH)
		)
	
	var a=	DIVIDE(AVERAGE('Table'[Cycle Time]) - __PREV_MONTH, __PREV_MONTH) return
IF(ISBLANK(AVERAGE('Table'[Cycle Time]))=FALSE()&&ISBLANK(a)=FALSE(),IF(a>1,-1,1)
)

    Then set conditional formatting for bar chart, add 

    By the way: for latest version power bi desktop, you could find condition formatting as above

    result:

    and here is pbix file, please try it.

     

    Best Regards,

    Lin

  • OwenAuger's avatar
    OwenAuger
    Super User
    7 years ago

    Anonymous 

    You can do something like below with the built-in waterfall - see attached pbix. I'm not sure if exactly meets your needs but hopefully close.

     

    I added a Dummy column containing the value "Change" on every row of the table containing Cycle Times.

     

    Then set Category = Month, Breakdown = Dummy and Y Axis = Average of Cycle Time.

     

    Regards,

    Owen