Results:

It’s not an exaggeration to state that organizations have hierarchies all around. Consider the following:  When a business wants to assess performance for a particular region, product or department against a benchmark, it is often helpful to analyse variances while traversing through a hierarchy. More often, analysis hierarchies can also include a combination of entities: […]

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

Welcome to the Inforiver Matrix October 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.7 release include:  1. Pivot mode One of the most widely requested features, Excel-like pivot mode is now available in Inforiver!Inforiver supports […]

Conditional formatting in dashboards and reports are key to guide users’ attention to specific performance areas. Compared to charts, tabular reports have higher information density which makes conditional formatting a lot more useful. The Power BI table and matrix visuals provide conditional formatting that can be applied in the form of font color, background color, […]

Migrating reports from Tableau to Power BI can get highly complicated depending on your report volume.   To ensure that your migration initiative goes successful, you need to consider the following factors before you commence the initiative:  Infrastructure: Understand the licensing landscape of Power BI as you have several options to choose from. Figure out which […]

If you think your Power BI report supports dynamic comments, think again. What are often implemented in Power BI reports as ‘Comments’ – either through PowerApps or third-party visuals – are simply filterable notes. But what is the difference? How does it matter? “Most implementations of ‘Comments’ in Power BI, including those in custom visuals, […]

Financial statements, sales forecasts, budget plans, annual reports, investor presentations, and many other forms of everyday reporting have one thing in common – they contain a lot of numeric data presented in tabular form. Presenting tabular data requires a slightly different approach than rendering a huge volume of text as seen in books and newspapers. […]

It is a common requirement across organizations to schedule Power BI reports on a periodic basis, where the report data (exported to Excel/PDF files) need to be sent by email to multiple recipients, or to shared folders such as OneDrive, Microsoft Teams, SharePoint and Google Drive. We’ll quickly explore how you can set this capability […]

Today we are going to take a quick look at how to calculate Month over Month (MoM), Quarter over Quarter (QoQ) and Year over Year (YoY) growth in Power BI, just as easy as you can do in Excel. We have a monthly P&L dataset in Excel starting Jan 2019 going all the way till Dec […]