Results:

A visual, including a table or a matrix, can typically accommodate multiple measures with some exceptions. Most visuals in tools such as Power BI, Tableau, Qlik and Spotfire tend to treat all measures equally and are also based on a single measure. However, this leads to poorer user experience.  Consider the following example.  At ACME […]

Related to Power BI Ideas: Turn off Matrix Total - https://ideas.powerbi.com/ideas/idea/?ideaid=f40be08a-dbbd-441a-a197-8282a13ff1ca  When we use the native matrix visual in Power BI, the process to turn off the grand total is not straightforward and intuitive. We can only turn off the totals or subtotals at a specific level as shown below:  In Inforiver matrix visual, we can […]

Welcome to the Inforiver Matrix December 2022 update. We are thrilled to announce several new features and key enhancements (for all the editions) most anticipated by our Inforiver community!    Key enhancements in this v1.8 release are listed below. Feel free to jump to any specific section for more details.  1. Report level notes & rich […]

Welcome to the Inforiver Enterprise December 2022 update. We are thrilled to announce several new features and key enhancements most anticipated by our Inforiver community!  Key enhancements in this 1.8 release are listed below. Feel free to jump to any specific section for more details.  1. New data input column – Person  v1.8 introduces a […]

This blog is reproduced from here. The Power BI Matrix visual is similar to an Excel Pivot table, however there are quite a few limitations in the Matrix. In the Power BI Matrix below I have put the product categories on Rows, Calendar Year on Columns and the measure [Total Sales] on Values. At this […]

Inforiver Charts for Power BI provides users with the capability to compare performance and benchmark with variance visualized in both absolute & % terms.  In this blog, let us look at some of the key capabilities delivered by Inforiver Charts for performing variance analysis.  1. Horizontal and vertical orientations  The variance chart is useful for […]

In an earlier blog, we explored how comments are different from notes, and how many Power BI ‘commenting’ solutions in the market today are in fact just implementations of ‘notes’.   Power BI does provide a native, true, out-of-the-box commenting capability. It supports report-level and visual-level commenting including @mentions and collaborative conversations. However, data level commenting […]

It’s not an exaggeration to state that organizations have hierarchies all around. Consider the following:  Regions - Country, State, City  Products – Categories, Subcategories, Products, SKUs  People – CXO, VP, Directors, Managers, Associates  Finance – General Ledger (GL) hierarchy  When a business wants to assess performance for a particular region, product or department against a […]

In Microsoft Power BI, quite often, the results in total rows do not correspond to the sum of the individual rows when DAX measures are used. This is because the total is computed based on the DAX formula. To obtain the correct total, one may have to write complicated DAX queries which is quite a […]

Welcome to the Inforiver Enterprise October 2022 update. We are thrilled to announce several new features and key enhancements most anticipated by our Inforiver community! Inforiver Enterprise SaaS edition is now available for purchase in Microsoft Appsource!  Key enhancements in this 1.7 release are listed below. Feel free to jump to any specific section for more details.  […]