Documentation Formatting
Common formatting tasks
Quick answers to the formatting changes people make most often.
| Task | Where |
|---|---|
| Switch to horizontal | Chart Options > Chart Orientation |
| Colour by favourable and adverse | Chart Options > Format using Sentiments, then Bar Colour |
| Colour each bar individually | Turn off Format using Sentiments, then Bar Colour |
| Drive bar colour from a measure | Bar Colour > fx |
| Show only the top steps | Chart Options > Limit Steps and Max Steps; rename via Other Step Title |
| Compare several waterfalls on one scale | Y-Axis > Minimum and Maximum (set the same values on each visual) |
| Stop long labels being cut off | X-Axis > Rotate labels, or Concatenate labels for hierarchies |
| Move the axis to the right | Y-Axis > Switch Y-Axis Position |
| Show values in millions | Labels > Value Format and Value decimal places |
| Hide zero bars | Labels > Hide Zero / Blank values |
| Add a total pillar automatically | Define Pillars > Show Cumulative Total |
| Keep bars readable when scrolling | X-Axis > turn off Fit to width, then set Minimum Bar Width |