Inforiver

Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Results:

Expand/collapse column hierarchy in Power BI

Currently in a native Power BI matrix, you cannot expand or collapse columns freely as you can do with rows. In the example below, even though we have assigned region, sub-region & quarter to Columns, only the region shows up by default, and there is no way to expand a specific region to reveal the […]

Read More

Group rows or columns in table / matrix reports in Power BI

Inforiver delivers a variety of spreadsheet-like capabilities that make it very appealing for Excel fans to embrace Power BI. A very popular feature of Excel that is missing in Power BI is the ability to group rows and columns. In Excel, this is accomplished using the Group (outline) settings property. Group rows in Power BI […]

Read More

Manually enter data in a new column in Power BI table/matrix

While reporting data using a Power BI table/matrix, we often encounter scenarios where we need to insert a new column and enter data manually. With Inforiver, you can create a new column and enter data manually as you do with excel. This is especially useful when the measure that we need is not already present in the data model, […]

Read More

Insert row and manually enter data in Power BI matrix reports

Quite often we would like to insert a row in our table / matrix reports in Power BI and enter our own data. For example, a financial statement report connecting to a database query may be able to fetch revenue & expense metrics. But it might not retrieve the number of shares outstanding. Similarly, a […]

Read More

Formatted Export to Excel / Spreadsheets in Power BI

With Inforiver, you can now perform formatted export to excel and PDF on your table / matrix reports in Microsoft Power BI. This means you can not only export but also retain the following while performing your export: report layout value & number formatting text/background colors & formatting notes & annotations row/column hierarchy structure, and […]

Read More

Custom sort / reorder rows & columns in Power BI

Till date, the options to perform a custom sort or reorder of rows (or columns) in Power BI have been limited. This is the case with many other BI tools as well. One common Power BI workaround requires you to modify your data model. You will need to create a separate column that defines a […]

Read More

Insert calculated measure or column in Power BI

With Inforiver, it is possible to insert a new calculated row, column or a measure at the visual-level in your Power BI table / matrix style reports, without writing DAX. The rows, measures and columns so created can also be formatted, rearranged, and utilized for downstream calculations. Let us take this example, where we have sales data […]

Read More

Change & manage aggregation in Power BI matrix

While working with Power BI table / matrix reports, we would sometimes like to apply custom measure aggregations in a specific report (e.g., average quantity sold) instead of using the default aggregation used in a data model (e.g., sum of quantity sold). Many times, changing the aggregation in the data model may not be possible […]

Read More

Hide, resize and reorder columns in Power BI matrix

Inforiver delivers a powerful 'Manage Columns' feature that helps you show/hide columns, reorder measures, resize columns by setting default column widths and apply custom aggregations in your Power BI table / matrix reports. To access this feature, click on the 'Manage Columns' dropdown from the top of the ribbon menu. Using the check boxes on […]

Read More

Manage totals & subtotals in Power BI

Be it a normal table or a hierarchical matrix style report in Power BI, Inforiver allows you to seamlessly manage subtotals and grand totals in a couple of clicks. Let us take the case of the following dataset, with hierarchies across both rows & columns. Note that (a) the row subtotals (Beverages & Water) are […]

Read More
Inforiver Logo
IBCS Certified
Power BI certified
About Inforiver!

Inforiver drives business productivity and business performance with faster time to insights inside Power BI through an intuitive no-code experience. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub
Headquarters
5920 Windhaven Pkwy, #130
Plano TX 75093
ValQ
xViz
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram