Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi I'm trying to map employee counts over a company on a map. For example my data looks like
State | Marketing | Sales | Factory | Management | |
ALABAMA | 160 | 336 | 862 | 28 | |
ALASKA | 237 | 461 | 576 | 28 | |
ARIZONA | 115 | 392 | 762 | 14 |
I would like to use a filled map that is filled based on the sum of all employees, but have a slicer that would recolor the map if I only cared about the distribution of a certain kind of employee (e.g marketing, mangement, etc).
Currently I can only have one value as the value used for the mapping, I can easily sum the numbers, but I cannot get the filtering to work.
Any help would be appreciated.
Solved! Go to Solution.
@Anonymous,
If I understand correctly, you are trying to seee Filled Map visualization by state and be able to filter by each department (Marketing, Sales, Factory, Management) ?
Let say, I have your sample data:
First, you need to unpivot data to have a tabular structure.
Select State column and go to Transform -> Unpivot Columns -> Unpivot Other Columns
You will get:
Then import the data and create visualization with filter by the new Attribute column:
Let me know if this helps. Thanks.
@Anonymous,
If I understand correctly, you are trying to seee Filled Map visualization by state and be able to filter by each department (Marketing, Sales, Factory, Management) ?
Let say, I have your sample data:
First, you need to unpivot data to have a tabular structure.
Select State column and go to Transform -> Unpivot Columns -> Unpivot Other Columns
You will get:
Then import the data and create visualization with filter by the new Attribute column:
Let me know if this helps. Thanks.
You're an absolute saint. The whole pivoting thing is something I'm still trying to grasp.
Thanks,
Chris
User | Count |
---|---|
92 | |
86 | |
67 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |