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
  • Sorting
  • Top / Bottom N

Was this helpful?

  1. Interactivity

Sorting and Top N

PreviousDynamic Deviation ChartsNextHighlighting

Last updated 7 months ago

Was this helpful?

The Innofalls Chart offer you the possibility to sort the elements in a chart. You can specify by which measure and/or dimension the chart should be sorted by. You can also sort by deviations to quickly identify elements with the largest impact.

You can activate sorting by either clicking on a axis label

When Top/Bottom N is active, you can also click the Rest label to open the settings dialog.

Sorting

When more than one measure or additional deviation charts are available in the visual, you can choose by which measure to sort by.

When the Stack / Columns field contains a dimension, you can select which member to sort by.

Sort Options

None

No sorting; the sort order given by Power BI is applied

Up

Sorts the values with the lowest value first by the specified sort measure. If only one measure is present in the chart, that one is taken and no measure choices are available

Down

Sorts the values with the highest value first by the specified sort measure. If only one measure is present in the chart, that one is taken and no measure choices are available

Top / Bottom N

You can apply this option, if you wish to limit the amount of elements shown in the chart. When this constraint is active, the N number of elements with the highest (top) or lowest (bottom) values are shown and all other elements are summarized in a rest member.

You can either specify a fixed number of elements to keep or you can choose one of the Auto settings to determine the number of elements to keep automatically. Auto is a good choice for responsive reports (e.g. mobile reports). The smaller the visual, the fewer elements are visible.

If the number of elements present is less than the constraint N, no Rest is generated.

You can rename the Rest member in the property pane under Sorting + Top N.

Top / Bottom N Options

None

No Top / Bottom N is applied

Auto Top

Keep top elements.

The amount of elements is determined by the size of the visual.

Auto Bottom

Keep bottom elements.

The amount of elements is determined by the size of the visual.

Top

Keep top elements specified by N.

Bottom

Keep bottom elements specified by N.

or by clicking the Sort and Top N button in the .

🧭
navigation menu
Sort and Top N Settings