Blogs

Achieve 20x Productivity in P&L/Financial Statement Reporting in Power BI

It takes 5 hours for a typical Power BI expert to build a moderately-complex P&L statement in Power BI. For an average user with basic to intermediate understanding of DAX, it may take anywhere from 3 to 5 days. However, Inforiver can help you deliver financial statements 10x to 30x faster, and often in as much as 5 minutes. I know it sounds too good to be true – but let me show […]

Read More

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

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. Inforiver delivers a similar spreadsheet-like Group functionality right inside Microsoft Power BI. Group Rows in Power BI table / matrix reports In the sample […]

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

How to Expand and Collapse Column Headers in Power BI

Power BI has been around since July 2015. Over the years, it has seen continuous improvement in both capability and functionality.  As I am sure you can appreciate, when developing new software from scratch, there is everything to do but limited time to do it.  The reality is that the work needs to be prioritized […]

Read More

Inforiver launches Standard Edition in Microsoft App Source

Inforiver recently launched its Standard Edition in Microsoft App Source. Following are the excerpts from the Power BI Monthly Blog (Nov 21). Inforiver delivers the fastest way to build visualizations and reports in Power BI. With Inforiver Standard Edition, you can create IBCS-compliant P&L/financial statements, variance reports and visualizations in a single click. The standard edition comes with […]

Read More

Calculate remaining budget in Power BI (without using DAX)

In Microsoft Power BI, you may often encounter incorrect total values while using calculated measures. Here is one such example. We have budget amounts for a few products (Budget Amount) and have incurred expenses against each (Posted Expenses). Our objective is to calculate remaining budget in a new column, and add them up. Let us […]

Read More

Custom sort / reorder of rows & columns in Power BI in seconds

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
Inforiver Logo
About Inforiver!

Inforiver delivers the fastest way to build collaborative reports in Power BI through a seamless low-code / no-code experience. The product is developed by Lumel Technologies, which has a decade of experience in building visualization products including ValQ, xViz and BI Hub.
ValQ
BI Hub
xViz
5920 Windhaven Pkwy, #130
Plano TX 75093
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram