Blogs

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

Inforiver is an idea that has been a long time in the making. While its look-and-feel draws comparison to Power BI table/matrix visuals, it is in reality a complete analytics platform framework that supports a wide variety of use cases. Without getting into technical details, I'll quickly cover six perspectives that guided us to building this product. 1. […]

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 […]

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 […]

Learn how you can deliver a P&L, financial, or an income statement, in less than five minutes in Power BI, without using DAX.