Inforiver
FormulaPricingProductAll Products
Reporting & Writeback Matrix Docs
Reporting & Writeback Matrix Docs
  • Introduction to Inforiver
    • Why Inforiver
    • Get Started
      • Installing Inforiver for yourself
      • Installing from AppSource
      • Installing Inforiver for your organization (Org visual)
      • Inforiver Writeback Matrix pre-requisites
        • Whitelist Inforiver IPs
        • Admin consent for Inforiver's Entra ID
          • Basic consent
          • Full admin consent
      • Inforiver Customer Portal
        • Billing Admin
          • Update Profile
          • Update Subscriptions
        • License Admin
      • Licensing
        • License renewal
      • Registering Inforiver on Azure AD (Entra ID)
  • Working with Inforiver
    • 1. Build your first Inforiver report
    • 2. Displaying information
      • Report interface
      • Layout options
      • Templates
      • Basic formatting
        • Number formatting
        • Cell, header & value formatting
        • Totals & subtotals
        • Insert blank rows
      • Basic inline charts
    • 3. Basic interactions
      • Explore & filter data
        • Search & Filter
        • Explorer
        • Top N + others
      • Sort & reorder data
      • Show/hide values
      • Manage column widths
      • Manage hierarchies
      • Create visual hierarchies
      • Pin rows & columns
      • Blend measures
      • Dynamic measure headers
      • Context menus
        • Column gripper
        • Row gripper
      • Actions
        • Rails
        • Toolbar options
        • Keyboard shortcuts
        • Reset
    • 4. Adding business logic and formulae
      • Insert calculated rows
        • Template rows
      • Insert calculated columns
      • Insert manual input rows
      • Insert manual input columns
        • Number
        • Dropdown
          • Dropdown options from semantic models
          • Lookup visuals for dropdowns
        • Text, checkbox & date
        • Writeback Matrix features
      • Invert sign
      • Editing cells
      • Quick formula
      • Visual column inside visual measures
      • Manage inserted rows
      • Manage inserted measures & columns
      • Pivot data
      • Insert image URLs
    • 6. Working with charts
      • Sparkline charts
      • Stacked charts
      • Bullet charts and clustered bar charts
      • Waterfall charts
      • Bar and pin charts
      • Change/deviation charts
    • 5. Conditional formatting
      • One-click options
      • Create rule
        • Rules (If conditions)
        • Color scale & data bars
        • Classification
        • Ranking
      • Manage rules
    • 7. Planning, budgeting & forecasting
      • What-if analysis & simulations
      • Goal Seek
      • Scenarios (Writeback Matrix only)
      • Budgeting & allocations
      • Forecasting
        • Date rollover and extending forecasts
        • Editing forecasts and reforecasting
        • Autoclose forecasts
        • Distribute deficit
        • Row level forecast
        • User Access Control
        • Common Scenarios
          • Forecast using a Blank Template
          • Forecast using Existing Data
          • Adding Forecasts for Periods unavailable in the model
          • Creating daily and weekly forecasts
      • Set version
    • 8. Paginated reporting
      • Pagination
      • Header & footer
        • Text
        • Images
        • Charts
        • KPI cards
      • Report layouts (Report+)
      • Display and themes
    • 9. Commenting and collaboration
      • Notes
      • Comments
        • Data-level comments
        • Assign & track tasks
        • Track changes
        • Report-level comments
        • Comment settings
    • 10. Exporting reports
      • Export to PDF & Excel
        • Excel export - operational boundaries
      • Ad hoc emails
      • Snapshot (Writeback Matrix only)
        • Comparing snapshots
    • 11. Scheduling reports
      • Create new subscription
        • Select a report
        • Set subscription frequency
        • Select destination(s)
          • Email
          • OneDrive
          • Microsoft Teams
          • SharePoint
        • Review & save subscription
      • Manage your subscriptions
      • Administration
    • 12. Data writeback
      • Settings
        • General Settings
        • Data Settings
        • Destination Settings
        • Writeback security settings
        • Writeback time-out & batch size settings
        • Advanced Settings
      • Destinations
        • Azure SQL (Managed DB)
        • Azure SQL
        • Microsoft SQL Server
        • Synapse Dedicated SQL Pool
        • Azure Data Lake Storage
        • Databricks
        • Snowflake
          • Setting up Snowflake OAuth
        • Amazon Redshift
        • BigQuery
        • SingleStore
        • SAP HANA
        • Oracle
        • PostgreSQL
        • MySQL
        • OneDrive
        • SharePoint
        • Dataverse
        • Fabric Warehouse
        • Fabric lakehouse
        • Fabric SQL
        • URL as destination
      • Logs
      • Reading mode
    • 13. Context awareness
    • 14. Manage aggregation
      • Row aggregation
      • Column aggregation
    • 15. Managing Inforiver Writeback Matrix visuals
      • Inforiver deployments in Power BI pipeline setup
      • Duplicating Writeback Matrix Visuals - Best Practices
      • Recommended practices while working with Power BI desktop
    • 16. Approval workflows
    • 17. Collaborative adjustment workflows
    • 18. Variables
      • Variable types
        • Number
        • Select
        • Text
        • Date
        • Date range
        • Boolean
        • Button
      • Variable bookmarks
  • Admin Console
    • Manage Profile
    • User management
      • User Roles and Permissions
      • Create custom roles and policies
    • Settings
      • General
      • Generate builds - on prem
      • Forecast
      • Holidays
      • API token
      • Writeback
      • Managed DB
      • Assets
    • Onboarding actions
    • Writeback
  • Display settings
    • General settings
    • Hierarchy settings
    • Number settings
    • Miscellaneous settings
    • On-load scripting
  • Formula syntax
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
      • FILTERIF
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • AVERAGEIF
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • INDEXOF
      • LOG
      • ODD
      • MAX
      • MIN
      • NORMDIST
      • NORMSDIST
      • NORMINV
      • NORMSINV
      • PCT
      • POWER
      • RAND
      • RANDBETWEEN
      • ROUND
      • SORT
      • SQRT
      • SUM
      • PMT
    • Text formatting functions
      • CONCATENATE
      • HYPERLINK
      • LEFT
      • LOWER
      • MID
      • PROPER
      • REPLACE
      • REPT
      • RIGHT
      • TEXT
      • TRIM
      • UPPER
      • VALUE
    • Date functions
      • DATEADD
      • DATEDIFF
      • DAY
      • DATE
      • DATE.SET
      • DATE.FORMAT
      • SOWEEK
      • SOMONTH
      • SOQTR
      • SOYEAR
      • EOWEEK
      • EOMONTH
      • EOQTR
      • EOYEAR
      • NETWORKDAYS
      • ADDDAYS
      • ADDWEEKS
      • ADDMONTHS
      • ADDQTRS
      • ADDYEARS
      • FROMEXCELDATE
      • MONTH
      • NOW
      • PERIOD_RANGE
      • TODAY
      • TOEXCELDATE
      • YEAR
    • Time intelligence functions
      • AGGREGATE
      • FILTER
      • COLUMN_PERIOD
      • LASTNDAY
      • LASTNMONTH
      • LASTNQTR
      • LASTNYEAR
      • MONTHPERIOD
      • MOVINGAVERAGE
      • MOVINGSUM
      • MTD
      • NEXTNDAY
      • NEXTNMONTH
      • NEXTNQTR
      • NEXTNYEAR
      • QTD
      • QTRPERIOD
      • SHIFT
      • TOTALYTD
      • TOTALQTD
      • TOTALMTD
      • VALUEAT
      • YEARPERIOD
      • YTD
    • Other operators
    • Identifiers
      • CLOSEDPERIOD
      • COLUMN.DATE
      • COLUMN.PARENT
      • COLUMNS
      • CURRENT_PERIOD
      • DESCENDANTS
      • FORECAST.CLOSED_END
      • FORECAST.CLOSED_START
      • FORECAST.OPEN_END
      • FORECAST.OPEN_START
      • GROUP INDEX
      • HAS
      • HAS_ALL
      • HAS_SOME
      • LEAVES
      • LEVEL
      • LOGGEDIN_EMAIL
      • LOGGEDIN_NAME
      • MATCH
      • MAXDATE
      • MEMBERS
      • MINDATE
      • RELATIVE
      • RELATIVE_COLUMN
      • ROW.PARENT
      • ROW.LABEL
    • Scripting functions
      • DISPLAYTOAST
      • EXPORT
      • LAYOUT
      • SETCFRULE
      • SETFILTER
      • SETFILTERBYINDEX
      • SETVISIBILITY
      • SHOWBETWEENPERIOD
      • SHOWCLOSEDFORECAST
      • TOPN
      • DISPLAY SETTINGS
        • SETBLANKLABEL
        • SETSUPPRESSZEROS
        • SETRAGGEDHIERARCHY
        • SEPARATOR
        • SETCOMBINECOLUMNHEADER
        • SEMANTICFORMAT
        • SHOWNULLAS
        • SHOWZEROAS
        • SINGLECHILD
    • Miscellaneous functions
      • FETCH
      • LOOKUP
    • Measure/Column selection functions
      • GETCOLBETWEENPERIODS
      • GETMEASURE
  • Advanced topics
    • Audit log
    • Backup & restore report config
    • Enterprise themes
    • PowerPoint integration
    • Drill down and roll up in performance mode
  • Infobridge
    • 1. Create bridge
    • 2. Add source to bridge
    • 3. Bridge Interface
    • 4. Manage queries
      • Query transformations
        • Append
        • Join
        • Duplicate
    • 4. Manage sources
    • 5. Insert rows from bridge
    • 6. Insert measure from bridge
    • 7. Manage Integration of visuals
    • 8. Manage Bridges
    • 9. Data transformations
      • Pivot table
      • Group by
      • Add Column
      • Pivot column
      • Rename column
      • Find and Replace
      • Remove measure
      • Filter rows
      • Sort
      • Text functions
      • Unnest
      • Round
      • Extract Comments
      • Import and export
    • 10. Integrating forecasts
    • 11. Collaborative adjustments
  • Accessibility shortcut keys
  • Inforiver Reporting Matrix FAQs
  • Inforiver Writeback Matrix FAQs
  • Leveraging Power BI bookmarks
  • Performance Optimization Options in Inforiver
  • Video tutorials
  • Resources
  • Release Notes
    • Inforiver Writeback Matrix May 2025 - v4.4.5
    • Inforiver Writeback Matrix May 2025 - v4.5 - Audit redesign, Writeback optimizations, and more
    • Inforiver Writeback Matrix May 2025 - v4.4.3
    • Inforiver Writeback Matrix April 2025 - v4.4.2
    • Inforiver Writeback Matrix April 2025 - v4.4.
    • Inforiver Writeback Matrix March 2025 - v4.3 - Time series formulae
    • Inforiver Writeback Matrix - March 2025 - v4.2
    • Inforiver Writeback Matrix March 2025 - v4.1
    • Inforiver Reporting Matrix March 2025 - V3.3.3 -New formatting and export options
    • Inforiver Writeback Matrix Feb 2025 - v4.0 - User permissions, High-performance mode, Input rules
    • Inforiver Writeback Matrix January 2025 - v3.9 - Fabric support, upgraded variables interface
    • Inforiver Writeback Matrix December 2024- v3.8 - Improved Scheduler Performance & Other Enhancements
    • Inforiver Writeback Matrix December 2024 - v3.7 - Merge rows, new rounding functions & More
    • Inforiver Writeback Matrix November 2024 - v3.6.2 - Import from Google Sheets & More
    • Inforiver Writeback Matrix October 2024 - v3.6 - Approval Workflows & Other Enhancements
    • Inforiver Writeback Matrix October 2024 - v3.5 - Lookup visuals & more
    • Inforiver Reporting Matrix Nov 2024 - v3.3 - Variables
Powered by GitBook
On this page
  • 1. Adding the chart
  • i) Bar charts
  • ii) Pin charts
  • 2. Customization options
  • i) Chart type
  • ii) Axis config
  • iii) Reference line
  • iv) Reference band
  • v) Comparison band
  • vi) Outliers
  • vii) Data label config
  • viii) Padding
  • ix) Fill pattern
  • x) Appearance

Was this helpful?

  1. Working with Inforiver
  2. 6. Working with charts

Bar and pin charts

PreviousWaterfall chartsNextChange/deviation charts

Last updated 1 year ago

Was this helpful?

Bar charts and pin charts are commonly used to display and compare data.

Bar charts are used to show the distribution of data within a set of categories or groups. Pin charts, also known as lollipop charts, are a variation of bar charts where a dot represents the data point and a segment connects it to the X-axis. It is often used to visualize data where the length of the bar is not as important as the value itself.

1. Adding the chart

i) Bar charts

Inforiver offers three variants of bar charts: Solid bar, Colored bar, and Invert-color bar.

In this example, we will visualize the magnitude of sales of the categories using a bar chart.

a) We have added 'Sub Category' in the 'Rows' field, and 'Sales', 'Margin', 'Margin %', and 'Total Customers' in the 'Values (AC)' field in the visualization pane.

b) Select the column for which you want to insert the bar chart. In the following image, the sales column has been selected.

The bar chart option gets enabled. From the 'Bar chart' drop-down, select the 'Solid bar chart'. i

ii) Pin charts

Inforiver offers three variants of pin charts: Simple, Bar colored, and Marker colored.

In this example, we will visualize the 'Margin%' using a pin chart.

a) We have added 'Sub Category' in the 'Rows' field, and 'Sales', 'Margin', 'Margin %', and 'Total Customers' in the 'Values (AC)' field in the visualization pane.

b) Select the column for which you want to insert the pin chart. In the following image, the margin % column has been selected.

The pin chart option gets enabled. From the 'Pin chart' drop-down, select the 'Simple pin chart'.

2. Customization options

Inserting a bar chart or a pin chart will open up the following configuration options.

i) Chart type

Here you can change your current chart type.

ii) Axis config

This option lets you configure the axis for the chart. Clicking on the 'Axis Config' option will open up the 'Axis modal' in which you can configure the following properties:

  • Axis direction - From this drop-down, you can set the direction of the axis to either 'Left to Right' or 'Right to Left'

  • Scaling - Using this drop-down you can set the scaling option to 'Universal' or 'By level'

  • Show Y Axis - Enable this check box if you want to display an axis on the Y Coordinate

  • Show X Axis - Enable this check box if you want to display an axis on the X coordinate

  • Hide ticks - With this option, you can either show/hide tick intervals

iii) Reference line

Reference lines are horizontal or vertical lines that are added to a chart to indicate a specific value or threshold. Using this option, you can add a reference line for values such as average, median or set a custom value.

Clicking on this option will open up a 'Reference line' modal to the right of the report.

Click on the 'Add New Line' button in the modal. This will open up a toolbar as shown below.

You can customize the following options in the reference line modal:

a) Value display - This option has two drop-downs.

From the first drop-down, you can select the data metric for which you want to display the reference line.

And the second drop-down lets you select the value at which the reference line needs to be inserted. You can select from the following values:

  1. Average - Inserts a reference line at the average value of the data metric

  2. Median - Inserts a reference line for the median value of the data metric

  3. Standard deviation - Inserts a reference line for the standard deviation of the data metric

  4. Mid value - Inserts a reference line at the mid value of the data metric

  5. Constant - If you select this option, an additional 'Static value' field becomes available. Using this option, you can set the static/constant value at which you want to insert the reference line.

b) Style - This option has three drop-downs.

From the first drop-down, you can choose the style of the reference line. You can choose from any of the following options: Dotted, Dashed, Solid, Long Dashed, or Double Solid.

From the second drop-down, you can select the color of the reference line.

And from the third drop-down, you can choose the position of the reference line. It has the following two options: Front - positions the reference line in front of data values, and Back - positions the reference line to the back of the data values.

After choosing all the customizations, click on 'Apply' to insert a reference line with chosen customization options.

Add more than one reference line - To add more than one reference line, you can click on the 'add new trend line' link at the bottom of the toolbar in the reference line modal.

Delete a reference line - To delete an existing reference line, click on the trash can/delete icon.

Disable a reference line - To disable an existing reference line, click on the toggle switch button.

iv) Reference band

Reference bands are similar to reference lines, but they are represented as a shaded area between two lines. They are used to indicate a range of values.

Clicking on this option will open up a 'Reference Band' modal.

From this modal, you can customize the following options

a) Value Display - This option has two drop-downs.

From the first drop-down, you can select the data metric for which you want to display the reference band.

And the second drop-down lets you select the ending value of the reference band. You can select from the following options:

  1. Average - The average value of the data metric is set as the ending value of the reference band

  2. Median - The median value of the data metric is set as the ending value of the reference band

  3. Standard deviation - The standard deviation of the data metric is set as the ending value of the reference band

  4. Mid value -The mid value of the data metric is set as the ending value of the reference band

  5. Constant - If you select this option, an additional 'Static Value' field becomes available. Using this option, you can set the static/constant value which is set as the ending value of the reference band.

b) Start From - Using this drop-down, you can select the starting value of the reference band. It has the following options:

  1. Min - The minimum value of the data metric becomes the starting value of the reference band

  2. Zero - Zero becomes the starting value of the reference band

3. Constant - If you select this option, a new input field becomes available where you can select the constant value which becomes the starting value of the reference band.

c) Line Style - The line style option allows you to set the style and color of the lines that get displayed at the starting and ending value of the reference band.

From the first drop-down, you can choose the style of the lines. You can choose from the following options: Dotted, Dashed, Solid, Long Dashed, and Double Solid.

And, from the second drop-down, you can select the color of the lines.

d) Background color - This color picker lets you choose the color for the shaded area in the reference band.

Delete reference band - To delete an inserted reference band, click on the 'Delete' button at the bottom of the 'Reference Band' modal.

v) Comparison band

The comparison band indicates the state of the measure depending on which band it resides in. They provide a performance rating to the value being measured where each color represents a different state.

You can add comparison bands by clicking on the 'Comparison bands' icon. The following properties are available:

  • Compared series - This drop-down lets you configure the range of comparison bands as values or percentages.

  • Dynamic - If you enable this checkbox, then the comparison band range will be added based on individual scaling.

  • Number of bands - Here you can set the number of bands required.

vi) Outliers

In the case of lollipop/pin charts, you can indicate the outliers that exceed the specified threshold values.

You can do this while creating a pin chart, or add them after creating a pin chart through the Customize tab.

  1. Select the measure and then select the 'Pin Chart' drop-down menu to add any of the pin chart options available. You can also select the measure that already has one.

  1. In the customization menu, click on the Outliers option.

  1. In the Outliers pop-up window, check Enable Outlier. If you wish to hide the values, select the option Disable Label. Enter the required positive and negative threshold values as shown below and Click Apply.

  1. After applying outliers, the report shows below, highlighting the profit values exceeding 15k.

vii) Data label config

This option lets you configure the properties related to the data label. You can configure the following properties:

  • Data label - This checkbox lets you show/hide data labels. Note that other options become available only if this option is enabled.

  • Bar overlap - By enabling this option, you can overlap the data labels over the bar. By default, this option is not enabled and the data labels are displayed next to the corresponding bar.

  • Data label flip - With this option, you can reverse/flip the positions of the data labels. By default, the labels are placed to the right of the bar. By enabling this option you can flip/reverse their position to the left with respect to the bars.

  • Show label - In this drop-down, you can select the format of the data label. You can display the data values as just labels (numbers), as percentages, or as both.

  • Percentage scaling - This drop-down gets enabled only if you have chosen 'Percentage' or 'Both' as the data format in the show label drop-down. Using this option you can configure the scaling of the percentage data label. The available scaling options are

    1. Universal - This is the default option and it indicates the percentage contribution of the value to the grand total.

    2. By level - Whereas 'By level' indicates the percentage contribution of the value to its parent level or category.

viii) Padding

You can configure the inner padding (the space between the bar and the top/bottom border of a cell) with this option. Increasing the padding value will increase the spacing.

ix) Fill pattern

You can customize the fill pattern to any of these IBCS notations: Solid, Outlined, or Hatched.

x) Appearance

Appearance has two sub-options - Color and Series display.

Color is applicable for both the bar and pin charts and lets you define properties such as the bar color, axis color, data label color etc.

Series display is only applicable for the pin chart and you can select the marker type and marker size.

Some of these properties/options may or may not be available depending on the inserted chart type and variant.

A) Colors

The following options can be accessed by clicking on the 'Colors' option in the case of both bar and pin charts.

a) Positive color - Using this option you can customize the positive color of the bar/marker

b) Negative color - Using this option you can customize the negative color of the bar/marker

c) Axis color - This option lets you set the axis color of the chart

d) Data label color - This option lets you set the color of the data labels in the chart

e) Bar color - This option is available only for solid bar charts and will let you customize the color of the bar

f) Gradient - Enabling this option will allow you to set a gradient color to your bar chart. If you enable this option, the Min and Max color options become available using which you can set the color for the min value and the max value.

B) Series display

The following options can be accessed by clicking on the 'Series display' option in the case of pin charts.

a) Marker type - You can set the marker type for your pin chart(s) using this option. The marker type drop-down has the following options: Square, Diamond, and Circle.

b) Marker size - This drop-down lets you configure the size of the marker in your pin charts. It has the following options: Mini, Small, Medium, and Large.

c) The solid bar chart gets inserted as shown below. You can see the 'Customize' tab in the toolbar and the following .

c) The simple pin chart gets inserted as shown below. You can see the 'Customize' tab in the toolbar and the following .

In this section, we covered bar and lollipop/pin charts. Navigate to the next section to learn more about the .

change/deviation charts
customization options
customization options
Data mapping
Column and chart type selection
Inserting a bar chart
Data mapping
Column and chart type selection
Inserting a simple pin chart
Bar chart type options
Axis config options
Reference line options
Reference line toolbar
Reference line constant option
Reference line style options
Reference line apply
Add new trend line
Delete reference line
Disable a reference line
Reference band options
Reference band value display
Reference band start from options
Reference band constant option
Reference band line style options
Delete a reference band
Comparison band options
Dynamic option
Click on Pin Charts drop-down menu
Click Outliers
Custom Outliers
Outliers
Data label flip
Percentage scaling options
Padding options
Fill pattern options
Appearance colors option
Appearance modal
Gradient option
Series display option in appearance
Marker type and size options