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)
Month: March 2021
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
Decision Tree for Data Visualizations?
Here is an interesting idea, can you have a prescriptive approach in selecting a right chart for your storytelling? In this article https://www.kdnuggets.com/2021/02/telling-great-data-story-visualization-decision-tree.html the author suggests that a simple decision tree can help you in guiding your choices. https://youtu.be/LW-50zDTteQ I found the approach to be very interesting, albeit not all branches of the decision tree … Continue reading Decision Tree for Data Visualizations?
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