In this blog, I’ll demonstrate how to create a color legend for a filled map in Power BI, guiding you through the process step by step.
Step 1:
Choose a dataset with a Location field, the Superstore dataset I have used here has the States of the US and Canada. Now open a blank report in Power BI. To create a map, click on the filled map icon and drop the location field( Here it is State/Province) in the field pane.
Step 2:
We need a new measure that calculates the total profit. To create a new measure, “Total Profit = SUM(Orders[Profit]) “.
Now, it’s time to colour the map. I will colour the map according to the profit of each state. To achieve this, go to ‘Format visual’ in the Visualizations tab, and click on the ‘Fill Colour’¸ It opens a colour pane, on click on the Conditional Formatting icon ‘fx’.
Step 3:
Now, it’s time to configure the map to be coloured based on Total Profit. In the provided screenshot, a Colour Filled Map has been created to represent profit distribution.
Click ‘OK‘
However, the colour legend is missing, making it unclear which colours correspond to profits and which indicate losses. Since this distinction is crucial, we will cover how to achieve it in Part 2 of the vlog. Stay tuned!