Price Volume Mix (PVM) calculation is one of the most popular topics on my blog and YouTube channel. Although, I have covered the DAX for the perfect PVM before, I have gotten a lot of requests to extend the PVM logic to include a separate bucket for discontinued products as well as new products. You … Continue reading Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)
Category: Tutorial
How to Fix Power BI Map Geocoding Issues
Have you ever tried to display your North American or European states on a map only to find that one or more of them have suddenly moved to Latin America or Africa? I know that I run into this issue all the time. In this video I will give you two strategies to make the … Continue reading How to Fix Power BI Map Geocoding Issues
Market Basket Analysis (Power BI DAX Tutorial)
I have decided to spend some more time on Market Basket Analysis, but before I get into the storytelling part of it, I had to clean up and fix a few things in the model file for the Market Basket Analysis that I created a few years ago. https://youtu.be/3OlZuXH9Y_g Market Basket Analysis is very important … Continue reading Market Basket Analysis (Power BI DAX Tutorial)
Dynamic Dropdown Navigation in PowerBI
I have already done a video/post on how to implement a static drop down navigation, so in this tutorial I will cover how to implement a dropdown navigation where options are dynamically populated based on the identity of the user. https://youtu.be/wcNYHmCMEuA The Power BI desktop file used in this tutorial can be downloaded here. The … Continue reading Dynamic Dropdown Navigation in PowerBI
What Kellogg Professor Got Wrong about Effectiveness and Honesty in Data Visualizations
Steven Franconeri, a Kellogg School of Management professor, has written a good article "4 keys to Effective – and Honest – Data Visualizations". I thought that he made some solid points; however, I strongly disagree with his opinion about what makes a chart honest or dishonest. https://youtu.be/E6A0cry7PUw As you look at the global temperature trend … Continue reading What Kellogg Professor Got Wrong about Effectiveness and Honesty in Data Visualizations
Power BI Best Practices Analyzer in Tabular Editor
Wanted to do a quick video on how to use Power BI Best Practices Analyzer using Tabular Editor. There was a great blog post on it here: https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/ that covered a lot of details on what best practices were there to be aware of as well as the tool itself. However, the article seemed to … Continue reading Power BI Best Practices Analyzer in Tabular Editor
Progressive Discount (Tax or Commission) Calculation (Power BI DAX Tutorial)
I have to warn you, this is NOT a level 100 or even 200 tutorial. If you decided to proceed, that you absolutely positively have to get that progressive calculation work and I will have to assume that your DAX is pretty good, otherwise you would not be even attempting to tackle this problem. Also, … Continue reading Progressive Discount (Tax or Commission) Calculation (Power BI DAX Tutorial)
Constant Currency Analysis (Power BI DAX Tutorial)
Constant currency analysis is very popular when we need to take out FX rate fluctuations from our analysis. There are many different methodologies that companies used for determining what constant FX rate to apply to the historical values. In our tutorial, we will take a look at the time window for our analysis, figure out … Continue reading Constant Currency Analysis (Power BI DAX Tutorial)
Data Persuasion with BI: Top 5 Reasons Your Last Presentation was a FAIL
Unfortunately, life is hard and in BI world we are guaranteed to fail with our Data Persuasion every now and then. Having failed with my BI presentations many a time, I decided to write this article and frame up my top five reasons why I did and also suggest a few things for what you … Continue reading Data Persuasion with BI: Top 5 Reasons Your Last Presentation was a FAIL
Cumulative Discount or Commission Calculation (Power BI DAX Tutorial)
If you are looking to challenge your DAX skills while trying to figure out how to calculate a Cumulative Discount (or a Cumulative Commission) then this tutorial is for you. https://youtu.be/9hGowlw4YPc A Cumulative discount is calculated by finding the cumulative sales in the specified discount window, and then, using the cumulative sales as the parameter … Continue reading Cumulative Discount or Commission Calculation (Power BI DAX Tutorial)