Innofalls Documentation
Back to WebsiteOpen Ticket
  • 🎉Overview
  • ▶️Getting Started
    • Installation
    • Create Your First Waterfall
    • Data Fields
      • Values From
      • Stack / Columns
      • Delta Fields
    • Videos
  • 🧭Interactivity
    • Navigation
      • Navigation Menu
      • Keyboard Shortcuts
      • Drill Down History
      • Drill Down Preview
    • Selections
    • Dynamic Deviation Charts
    • Sorting and Top N
    • Highlighting
    • Restrict User Controls
    • Animations
  • 📊Chart Types
    • Overview
    • Waterfall Charts
      • Running / Intermediate Total Waterfalls
      • Intermediate Totals and Sub Totals
      • Delta Waterfall Charts
      • Measure Delta Waterfall Chart
      • Deviation Waterfall Charts
    • Other Chart Types
      • Bar Charts
      • Stacked Bar Charts
    • Automatic Chart Selection Feature
    • Chart Orientation / Rotation
    • Adding Deviation Charts
    • Changing Deviation Charts Types
    • Special Value Treatment
  • 🎨Formatting
    • Label Formatting
    • Scenarios
    • Themes
    • Colors
    • Conditional Formatting
  • 👩‍🎓Examples
    • 📈Profit and Loss Statement
    • IBCS Styled Bar Chart with Deviations
    • Quick Examples
      • Waterfalls in Columns
      • Products Stacked by Segments
      • Comparing Quarters
      • Comparing Measures
      • Delta Waterfall by Drill Down Combination
      • IBCS Bar Chart
  • 🔑Licenses
    • Trial License
    • Paid Licenses
    • Assign Paid Licenses
    • Free License
    • Publishing to the Web
  • ❕Additional Information
    • Data Security Overview
    • Change Log
Powered by GitBook
On this page
  • Stacking
  • Columns

Was this helpful?

  1. Getting Started
  2. Data Fields

Stack / Columns

PreviousValues FromNextDelta Fields

Last updated 11 months ago

Was this helpful?

The Stack / Columns field can be used to either stack values of a dimension on top of each other or to split values into columns (or rows in time orientation). Whether stacks or columns are created is determined by the Stack / Column mode in the menu. The default setting is Stack Mode.

Stacking

Besides adding multiple measures into the Values field, you can create a stacked waterfall or bar chart by adding a dimension into the Stack / Columns field while in Stack Mode.

Each element of the chart is then split into multiple segments. The basic bar chart creates multiple series from the stacking dimension.

Columns

Another use of this field is splitting the chart into multiple columns in Column Mode. You can select this mode in the menu:

You can also select the Stack / Columns Mode in the property pane.

You have the choice of three modes for columns, which allow for each combination of stacking and/or columns of the Stack / Column dimension and multiple measures in the Values field.

Columns by Dimension / Measure

Create a column for each combination of measures and members.

A dimension Product with 4 members and 2 measures in values creates 4 x 2 = 8 columns.

Columns by Dimensions

One column for each member of the Stack / Column dimension. Multiple measures in the Values field are being stacked.

Columns by Measures

One column for each measure. The dimension from the Stack / Column field is used for stacking.

Please note that for performance reasons the count of columns is limited to 12.

▶️
Stacking by Product, "Power BI" Theme for more contrasting colors
Stack / Column Mode Selection
Columns by Dimension (Product)