Dynamic Pareto Chart in Power BI In this post I want to share my technique of building a dynamic Pareto Chart. Pareto charts are used to show the 80/20 rule according to which roughly 80% of
Category Archives: DAX
Multiple Hierarchies Sometimes in Power BI you may want to build reports like the one in the screenshot below, where items are part of multiple hierarchies. You can see that items are categorized by color
Dynamic Percentiles using DAX Using DAX, it is not so difficult to find out who your Top 25% Customers are for a given product and what is the Sales Amount of these Top customers. Download
Correlation Matrix using DAX In this post I wanted to share one way you could calculate a correlation matrix by using DAX. I downloaded stock prices data from Yahoo for the month of September 2018