Results:

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

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

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

Inforiver for Power BI comes prepackaged with intelligent number formatting & scaling recognition capabilities that help display data in a perceptive manner in your table / matrix style reports right out of the box. The in-built intelligence does the hard work so that you do not have to. Let us take a sample dataset as […]

Inforiver provides one of the fastest ways to build reports in Power BI, and a key ingredient that enables this is the availability of one-click business templates. Let us take a quick look at how to use them. Launch Inforiver in full screen mode. You will be shown two options – 'Build report manually' and […]