Results:

Organizational data can grow at gigabytes or even petabytes per day, subject to the type of industry. Business reporting involves cross-referencing data from multiple tables and different semantic models, ensuring data integrity for massive data volumes is nearly impossible if the data is manually maintained. The Inforiver Lookup visual has been designed to help you […]

When exporting data in a Power BI table or matrix report to Excel, you quickly encounter a few limitations.  To illustrate this, let us take this sample report built using the matrix visual available in Power BI. You get the following when you export the matrix to an Excel file.  You will notice the following […]

Perform formatted exports to PDF from your Power BI reports. 1. Export only select columns and measures from your tabular and matrix reports  Export the entire table/matrix or select specific columns using the ‘Selected Columns’ option in the toolbar. In the following example, only the last three quarters are exported to the PDF file. 2. […]

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

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

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 Watch the following video to learn more about manual data entry and how […]

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

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

When dealing with Power BI table/matrix reports, there might be occasions where we prefer to apply customized measure aggregations in a particular report—such as calculating the average quantity sold at the company level —rather than relying on the default aggregation specified in the data model, like the sum of quantity sold.  Often, altering the aggregation […]