Part II – The Definitive Guide to Price Volume Mix Calculation (PVM) in Power BI – The Perfect Mix

In the Part I of this series, I mentioned that I was cutting some corners with my calculation for the sake of giving you a simple and performant formula that was "good enough". Well, what if it is not good enough and you will not settle for anything other than the perfect math??? Well, the … Continue reading Part II – The Definitive Guide to Price Volume Mix Calculation (PVM) in Power BI – The Perfect Mix

Part I – The Definitive Guide to Price Volume Mix Calculation (PVM) in Power BI – Theory

Edit: I recommend that you watch this video first as I cover the important theory in detail and then go to the Part II for the final calculation analysis. Having been bombarded by many requests via LinkedIn, YouTube and this blog to provide additional information about Price Volume Mix calculation, I finally found some time … Continue reading Part I – The Definitive Guide to Price Volume Mix Calculation (PVM) in Power BI – Theory

Build an Ultimate KPI Using a Smart Narrative (Power BI Tutorial)

Until now, I have not been very successful with building a perfect KPI visual that would meet my criteria of being able to show the three critical data points that define a KPI for me: Actual ValueTarget ValueTrend (UP, DOWN, SAME) The out of the box KPI visual has so many limitations that I should … Continue reading Build an Ultimate KPI Using a Smart Narrative (Power BI Tutorial)

How to Build a Multi-KPI Comparator Using Calculation Groups (Power BI DAX Tutorial)

As the name suggests, a multi-kpi comparator allows you to compare multiple KPIs or measures on the same chart. This way you can dramatically reduce the clutter on your Power BI report page. You can select what measure you would like to see in bars for example and which one should go into a line. … Continue reading How to Build a Multi-KPI Comparator Using Calculation Groups (Power BI DAX Tutorial)

Anomaly Detection Calculation Using DAX (Power BI Tutorial)

I am not trying to take Microsoft out of business, but after I read on the Power BI team's blog that the anomaly detection feature was coming, I decided to see if I could implement something like this myself using DAX. Turns out we can build something very useful without having to run regressions and … Continue reading Anomaly Detection Calculation Using DAX (Power BI Tutorial)

Power BI Smart Narrative Visual Review – Is It Ready for Primetime???

Lots of good announcements for Power BI happened this week. One piece of technology I was looking forward to was Smart Narratives visual. You will have to download the latest version of Power BI desktop and then go to Options and enable it there. After that you can add a Smart Narrative visual by either … Continue reading Power BI Smart Narrative Visual Review – Is It Ready for Primetime???

Supercharge KPIs with Rankings (When Trend And Target Are Not Enough) (Plus a RANKX() DAX Function Tutorial)

A few posts ago I talked about KPIs and how they can be significantly improved by adding a trend. The question is, however, can we do even better? Can we have a current value, a target and a trend and still add more color to a KPI? Turns out that we can, and we can … Continue reading Supercharge KPIs with Rankings (When Trend And Target Are Not Enough) (Plus a RANKX() DAX Function Tutorial)

Custom KPI Trend Calculation – UP ↑ – DOWN ↓ – or About The Same → (PowerBI DAX Tutorial)

Imaging a scenario where your monthly sales are $80 while the budge value for sales was supposed to be $100. Obviously, you are not making your number. However, would you rather be 20% short but with sales trending up or 20% short but sales trending down? I think that most people would agree that the … Continue reading Custom KPI Trend Calculation – UP ↑ – DOWN ↓ – or About The Same → (PowerBI DAX Tutorial)