Forum Discussion
NDD
4 years agoFrequent Visitor
Waterfall chart help
Hi, NDD
Please try following steps to create water fall chart.
1.Enter two table as below:
2.Add a mesure like:
Value = VAR a = [Forecast Capacity] RETURN SWITCH ( SELECTEDVALUE ( 'Categroy Table'[Category] ), "Forecast", SWITCH ( SELECTEDVALUE ( 'Breakdown Table'[Breakdown] ), "Total Time", -1 * Table1[_Total Time], "Unproductive Time", -1 * [_Unproductive Time], "Over Time", -1 * [_Over Time], [Forecast Capacity] ), "Real", SWITCH ( SELECTEDVALUE ( 'Breakdown Table'[Breakdown] ), "Total Time", 0, "Unproductive Time", 0, "Over Time", 0, [_real] ) )Then apply these new fields to waterfall chart like below:
Best Regards,
Community Support Team _ Eason
3 Replies
- v-easonf-msftCommunity Support
Hi, NDD
Please try following steps to create water fall chart.
1.Enter two table as below:
2.Add a mesure like:
Value = VAR a = [Forecast Capacity] RETURN SWITCH ( SELECTEDVALUE ( 'Categroy Table'[Category] ), "Forecast", SWITCH ( SELECTEDVALUE ( 'Breakdown Table'[Breakdown] ), "Total Time", -1 * Table1[_Total Time], "Unproductive Time", -1 * [_Unproductive Time], "Over Time", -1 * [_Over Time], [Forecast Capacity] ), "Real", SWITCH ( SELECTEDVALUE ( 'Breakdown Table'[Breakdown] ), "Total Time", 0, "Unproductive Time", 0, "Over Time", 0, [_real] ) )Then apply these new fields to waterfall chart like below:
Best Regards,
Community Support Team _ Eason- khalifeNew Member
hello !
This is very close to what I am trying to achieve. My idea is to always go from 100% and go down to multiple not only one result (blue column) as per below photo. I hope you are able to help and many thanks in advance !