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
    • 19. Leveraging Power BI 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
  • Video tutorials
  • Resources
  • Release Notes
    • 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. Creating a list of values
  • a) List
  • b) Presets
  • c) Text columns(For Inforiver Writeback Matrix only)
  • d) Localization settings
  • 2. Editing the LOVs
  • 3. Options Style
  • 4. Allow user to add new option
  • 5. Entry in total/subtotal rows
  • 6. Default Value
  • 7. Using the dropdown
  • 8. Dynamically adding missing options

Was this helpful?

  1. Working with Inforiver
  2. 4. Adding business logic and formulae
  3. Insert manual input columns

Dropdown

PreviousNumberNextDropdown options from semantic models

Last updated 2 months ago

Was this helpful?

Inforiver provides options to create single-select or multi-select lists on your own, use one of the preset options or create from your Power BI datasets.

The single-select and multi-select columns have two main differences:

  1. The obvious one is that a single-select column accepts only one option as input whereas, the multi-select column doesn't have that restriction.

  2. There are presets available for creating a list of values in the case of the single-select column whereas the same is not available for multi-select columns.

In this section, we'll cover single-select columns. The same steps can be followed for multi-select except for the two points mentioned above.

Click on the 'Single Select' option in the dropdown.

1. Creating a list of values

There are two ways to create a list of values (LOVs) in Inforiver Reporting Matrix. The third option - Semantic model - which is greyed out is available only in Inforiver Writeback Matrix and is covered in the next section.

a) List

On clicking 'List', three default options along with colors are displayed. You can rename the options as required and click Create to create a new list with three options.

b) Presets

On clicking 'Presets', a pop-up screen opens. The list of values for each preset can be seen on hover. Select the required preset and Click Apply.

The list of values that gets created is shown below.

c) Text columns(For Inforiver Writeback Matrix only)

Follow the steps below to reference the values from one visual in another visual:

STEP 1: Copy the visual ID from visual 1 (Regional Sales).

STEP 2: Create a single-select or multi-select dropdown field in visual 2 (Product Sales).

STEP 3: In the Advanced section of the single select in visual 2 (Product Sales), enter the visual ID from step 1. Once the visual ID is entered, you will be able to select the text column(Region Entity) from the Column dropdown under the Advanced section.

Notice how the values in the single select are being populated from the Regional Sales visual.

d) Localization settings

You can configure and display the dropdown options based on the current language settings in Power BI. Navigate to Display Settings > General > Localization Settings to create necessary translation entries.

You can use the GETLOCALELABEL function to retrieve the dropdown options and the column title in the language that the report consumer has selected. In the example, the locale is set to French and the options automatically are translated into French.

2. Editing the LOVs

Changes to data input columns can be achieved using the 'Manage' option in the toolbar.

The data input side panel opens up. You can make the changes as desired.

Editing the options

The names, order, and color of the options can be modified and they can be added or deleted as well. To edit the names, type over the existing names in the text boxes.

Adding new options

To create a new option, click on the 'Add option'. Type the name in the text box and click 'Enter'. The option gets created as shown below.

Changing the color associated with each option

To change the color, click on the color dropdown. A color picker opens. Choose a color as desired.

To reorder or delete options, use the highlighted icons.

Icon position

This option allows you to hide or display the icon in the options to the left or right of data.

3. Options Style

This option lets you choose your desired display style for single and multi-select dropdowns: Chip, Arrow, or Plain text.

In the image below, we used the plain-text style for the multi-select dropdown, whereas, for the single-select, we’ve used the chip and arrow styles.

4. Allow user to add new option

Enabling this option allows users to create new options dynamically while using the dropdown, without the need to open the side panel for adding options.

5. Entry in total/subtotal rows

By default, data can be entered in total/subtotal rows. To disable it, uncheck the checkbox highlighted in the below image.

On trying to select an option in the total/subtotal row, a message as shown in the image is displayed.

6. Default Value

When you create a single-select data input field, you can specify a default choice to avoid blanks in your reports.

Static: When you use the static option, you can select the relevant default value from the Value dropdown. In this report, we’ve chosen the ‘Approval Status’ preset. Notice how the Value dropdown for default values contains options relevant to approval status. Even if you specify custom options with the Lists, Inforiver will populate the manually entered options in the default value dropdown.

Dimension: You can choose to set a dimension category as the default value. Please be mindful that if you choose to source default values from a dimension, you will need to enable the Allow user to add new option checkbox.

Measure: You can choose to set a measure as the default value. Please be mindful that if you choose to source default values from a measure, you will need to enable the Allow user to add new option checkbox.

7. Using the dropdown

Once the necessary changes are made to the list of values, and other properties are configured, click 'Create' in the data input side panel. Click on a cell in the data input column to enable the dropdown and choose an option.

8. Dynamically adding missing options

Users can create a new option on the fly if a particular option is not available in LOV. In the example below, the available values are ‘Submitted’, ‘In Review’, and ‘Approved’.

To add a new value of ‘Rejected’, type the new value in the search bar and click on the ‘Create’ button.

To allow users to input custom options, the Allow user to add new option should be enabled in the Single-Select/Multi-Select configuration.

The new value gets added to the list.

In the next section, we'll cover other data input types such as text, checkbox, and date.

If you are using Inforiver Writeback Matrix, you need to to start inserting a dropdown column.

Some of the properties such as and are covered in earlier sections.

Inforiver allows you to source dropdown values from belonging to a different visual. The visual ID is required to reference a different visual. You can obtain the visual ID from the profile as shown in the image below.

For organizations with a global presence, Inforiver allows you to provide translation support for users in their native language.

sign in
Insert as Visual measure/column
Allow input
text data input columns
Dropdowns - overview
Learn more about localization settings.
Data Input type - Single Select
Creating a list of values
New list created with three options
Using a preset list of values
List of values from presets
Text data input column in a different visual
Select text column from another visual
Region values are sourced from the Regional Sales visual
Localization settings
GETLOCALELABEL function for single select
Manage inserted data input column
Editing properties
Editing the names
Add an option
Enter the name
Option created
Changing the color
Reordering or deleting options
Icon position in the options
Options Style
Example for chip, arrow and plain text styles
Allow user to add new option
Disabling input in total/subtotal rows
Entry disabled in total/subtotal rows
Static default value
Default values from a dimension
Default options from a measure
Selecting from the dropdown
Available options in the LOV
Adding a new value to a LOV
New value added to the LOV