Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)

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)

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

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)

How Good are Your Chart Choices?

I found this interesting chart on Datawrapper.de and it made me think about how (and whether) my chart selections also changed over time. https://youtu.be/NV5QeQdnv1Y (Datawrapper is a pretty cool tool that allows users to upload their data and create pretty stunning visualizations) In this chart, Datawrapper has analyzed changes in distribution of chart styles selected … Continue reading How Good are Your Chart Choices?

Tools to Check If Your Reports are Color-Blind People Friendly

I have to admit that up until recently I have been oblivious to this topic myself. I am not a graphics designer, but I have always tried to pay attention to the esthetics of my reports/charts; picking colors and palettes was something that I would spend a considerable amount of time obsessing about. A short … Continue reading Tools to Check If Your Reports are Color-Blind People Friendly

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)