Hello,
I have a few things I would like to include on Map visual:
First, I would like to have the Country and Works for Region category (employees working from an office in Africa can be in the cost center of Europe since it works for projects related to Europe - Works for Region = Europe). Then I would like that the size of a bubble represents the number of employees working from the specific Country. In the end, I want that the color of a country represents the cost of working there (we have classified them from 1-4, 1 being the highest one).
What do I want to achieve?
I want to select on slicer "Works for region" - Europe, and then I want to see in which countries employees sit, bubble size representing the number of employees and the colour of a country representing the cost.