Day two of the dashboard week was all about advanced DAX calculations in Power BI. And I took a closer look at the ranking function RANKX.
Sometimes you just want to rank your data in order to evaluate your items. For example you have categories with several different sub-categories and want to see their performance based on sales. With the RANKX function in Power BI you can easily build that, also with dynamic changes according to your filters.
You can select the categories and the ranking changes accordingly.
You can also filter within the categories and the rank will change as well. In this case I deselected “Bookcases” and “Chairs” is now on rank 1.
And in case you want to find out about the top 20% of your products, making around 80% of your profit (or total sales in this case) you can build a pareto chart.
First I built a helper table to check my data and my new calculations. Also did a little rank function here. In the end I built the pareto chart.
Now you can find how I created both reports and build them yourself, with this online Tutorial: Dynamic Ranking and Pareto Chart Tutorial