In Today's article, we would like to use an interesting solution. The solution is to color the map based on winners or runner-ups. We are going to use the sales data for this use case. And our winners are Brand, Category, Sub Category, City, Item etc.
For this, we have created sales data. We have used some random functions to generate this data. So, you might see some consistency in Data.
We have the following data points
Sales Fact. We have only base measures from the source excel. The rest of the measures/columns are created in Power BI. You can find calculation in the pbix file.
Date - Calendar created in Power BI using the calendar function
From the base data, we have created the following measures
Last month, Last Qtr, Last Year MOM, QOQ and YOY for Net sales
But here we are only going to use the Discount % measure, and on Discount %, we have created Category and Brand Rank. So, we can filter Top rank on the Map.