Forum Discussion
Waterfall Chart Start and End Value
Hi everyone, I am currently trying to construct a waterfall chart and have run into a few challenges. Specifically, I am trying to create a chart that has a start and end value (Actual value and ...
OwenAuger
Super User
Super User
It is possible to get a waterfall visual to do this, but it may require creating appropriate dimensions/measures to use on the visual.
Would you mind sharing some sample data, at least to show the structure of your tables? This will affect how the measures are written.
With the built-in waterfall visual, you place fields on Category/Breakpoint and a measure on Y Axis.
- The Y Axis measure is evaluated for each value of Category to produce total bars
- The Y Axis measure is evaluated again for each pair of adjacent values of Category, with each Breakdown filter applied in turn, and the difference produces the movement bars.
Regards,
Owen