Getting Started – Waterfall & Variance

Minimum Requirements | License | Features | Chart Modes | Troubleshooting

Finance teams across industries use the LeapLytics Waterfall & Variance visual to present budget variances, revenue bridges, cost breakdowns, and P&L analysis directly inside Power BI. The visual is fast and built for professional financial reporting. With features such as five chart modes, automatic variance calculation, scale break for focused analysis, users gain immediate clarity on what’s driving the numbers.

If your financial data is available, you can fully configure and operationalize the LeapLytics Waterfall & Variance visual in under 2 minutes. You will have a functioning waterfall chart including categories, values, variance indicators, and formatting—ready for board presentations, management reporting, and stakeholder analysis.

Minimum Requirements

⚠️ Important: Your data should follow a tabular structure with each row representing a category and columns containing values.

The visual requires only a minimal set of fields to produce a fully functional chart. Each data point must include a Category (text field for labels like months, products, or cost centers) and a Value (numeric measure for the actual amounts). With just these two fields, the visual automatically renders a professional waterfall or bar chart.

The visual interprets your data automatically based on the chart mode you select. In Bar Chart mode, each category displays as an independent bar from zero. In Waterfall mode, the visual calculates running totals and shows how each value contributes to the final result. Line, Area, and Lollipop modes provide alternative perspectives on the same data.


  -- =====================================================
  -- REQUIRED FIELDS (Minimum data needed)
  -- =====================================================
  'January'                 AS Category,             -- Category label (text)
  150000                    AS Value,                -- Numeric value (measure)

  -- ===== CHART MODES SUPPORTED =====
  -- The visual offers five chart modes for different perspectives:
  --
  -- 1. Bar Chart:     Independent bars from zero baseline
  -- 2. Waterfall:     Running totals showing cumulative flow
  -- 3. Line:          Connected data points showing trends
  -- 4. Area:          Filled area with variance coloring
  -- 5. Lollipop:      Stems with dots for clean presentation
  --
  -- ===== NOTES =====
  -- • Category: Text field for labels (months, products, cost centers)
  -- • Value: Numeric measure (revenue, costs, variance amounts)
  -- • All chart modes use the same data fields

License

Copy your license code and paste it into the License field by pressing CTRL+V. If you do not yet have a trial license, you can request one here.

Features

The LeapLytics Waterfall & Variance visual provides professional-grade financial visualization with features such as five chart modes, automatic variance calculation, scale break for focused analysis, waterfall connectors, customizable colors, and responsive data labels. It automatically adapts to your data, displays matching visualizations, and offers complete styling options—ensuring clear, professional reporting directly inside Power BI.

If your data is available, you can set up a fully functional waterfall chart—including categories, values, formatting, and chart mode selection—in under 2 minutes. The visual adapts instantly to the fields you provide, enabling fast configuration with minimal effort and delivering a ready-to-use chart for finance teams, executives, and stakeholders.

Chart Modes

The visual offers five chart modes that you can switch between with a single click using the dropdown in the header. Each mode provides a different perspective on your data:

Bar Chart: Classic comparison view with independent bars from zero
Waterfall: Bridge chart showing how values build to a total
Line: Connected data points for trend visualization
Area: Filled area with automatic variance coloring (green above baseline, red below)
Lollipop: Clean presentation with stems and dots

Switch between modes to tell different stories with the same data—show the bridge in a board meeting, then switch to line mode to discuss trends.

Waterfall Connectors

In Waterfall mode, the visual automatically displays connector lines (also called bridge lines) that show how each value connects to the next. These horizontal lines make it immediately clear how the running total flows from one category to the next, helping stakeholders understand the “walk” from starting value to ending value. Connectors can be toggled on or off in the format panel.

Scale Break

When your baseline is millions and your variances are thousands, the differences become nearly invisible. The Scale Break feature (available in Line and Area modes) compresses the Y-axis to focus on what matters—the actual data range rather than starting from zero. Hover over the chart to reveal the scale break indicator, then click to toggle between full scale and compressed view. A visual zigzag symbol indicates when the scale is compressed.

Value Comparison Indicator

The Value Comparison Indicator automatically calculates and displays the variance between data points. An arrow with color coding (green for positive, red for negative) shows the direction and magnitude of change. Configure it to show:

Relative (%): Percentage change between values
Absolute: Actual numeric difference
Both: Combined view with amount and percentage
None: Arrow only without label

Choose comparison modes like First vs Last, Previous vs Last, or Lowest vs Highest to highlight the variance that matters most for your analysis.

Color Coding

Customize colors to match your corporate branding or follow standards. Configure separate colors for:

Positive values: Increases, favorable variances (default: green)
Negative values: Decreases, unfavorable variances (default: red)
Total bars: Starting values and totals (default: gray)

In Bar Chart mode, all bars use a neutral color for clean comparison. In Waterfall mode, bars are automatically colored based on whether they represent increases or decreases.

Troubleshooting

Data Not Displaying

Chart appears empty or shows landing page:

✅ Verify that both Category and Value fields are mapped in the data pane
✅ Check that Category field contains text values (not null)
✅ Ensure Value field contains numeric data (not text)
✅ Confirm your data source has at least one row of valid data

Chart Mode Issues

Chart mode not switching or displaying incorrectly:

✅ Use the dropdown in the visual header to switch modes
✅ Refresh the visual if mode doesn’t update immediately
✅ Check that data labels setting is appropriate for the selected mode
✅ Verify connector setting is enabled for Waterfall mode

Scale Break Not Appearing

Scale break indicator not visible:

✅ Scale break is only available in Line and Area modes
✅ Enable “Scale Break” in the Axis settings of the format panel
✅ Hover over the chart to reveal the scale break indicator on the right edge
✅ Click the indicator to toggle between full scale and compressed view

Label Display Problems

Data labels not showing or overlapping:

✅ Enable “Show Data Labels” in the Data Labels settings
✅ Try different label positions (Auto, Inside, Outside)
✅ Reduce font size if labels are overlapping
✅ Labels automatically adjust format (K, M, B) based on value magnitude

Best Practices

Data Quality: Ensure categories are unique and values are numeric; avoid null values
Category Order: Sort your data in the order you want it displayed (chronological for time series, logical for cost breakdowns)
Chart Mode Selection: Use Waterfall for bridges, Bar Chart for comparisons, Line/Area for trends
Color Consistency: Use consistent colors across reports (green for positive, red for negative)
Scale Break Usage: Enable for Line/Area modes when baseline dominates the view

Use Cases Reference

Use Case	Recommended Mode	Key Features	Example Data
Revenue Bridge	Waterfall	Connectors, Color coding	Prior Year → Price → Volume → Mix → Current Year
Budget Variance	Bar Chart	Variance indicator, Labels	Budget vs Actual by department
Monthly Trend	Line / Area	Scale break, Trend lines	Revenue by month (Jan-Dec)
Cost Breakdown	Waterfall	Running totals, Totals	Total Cost → Components → Net Cost
P&L Walk	Waterfall	Connectors, Color coding	Revenue → COGS → OpEx → EBIT
YoY Comparison	Bar Chart	Variance arrow, Labels	This Year vs Last Year by product

Supported Data Sources

Data Source	Status	Integration Notes
Excel/CSV	✅ Primary	Direct Power BI import with Category and Value columns
SQL Server	✅ Primary	Direct connection or import mode
SAP	✅ Primary	SAP BW, SAP HANA via Power BI connectors
Oracle	✅ Primary	Direct connection via Oracle connector
Dynamics 365	✅ Primary	Finance and Operations data via Dataverse
SharePoint	✅ Secondary	Excel files or SharePoint lists
Azure Synapse	✅ Primary	Direct connection to analytical data
Dataflows	✅ Primary	Power BI dataflows for prepared data