Blogs

The typical star-schema data model consists of a set of dimension tables, and a single fact table. The fact table holds measures such as Sales, Quantity, Units and more. Dimensions such as time (e.g., Year, Quarter and Month) and other categories (e.g., regions, products, and sales reps) are used to slice and dice these measures.   […]

Related to Power BI Ideas - https://ideas.powerbi.com/ideas/idea/?ideaid=5f1ab43a-2137-4cec-a040-0d5ec3511e93  Often times in a Power BI matrix, we would like to apply conditional formatting to specific levels in a hierarchy.  Let us take the example below which features sales by Country and Product type in rows, and Segment in columns. We would like to conditionally format any products […]

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