Forum Discussion
Solved
Getting my data broken down by states?
Hi all! I have my data broken down by states in one column but I want to be able to pull it in by regions with specific states. How can I easily do that? Im new into power BI and really try...
okay so i would do west, south, mid west and north east. within that would be the states, but how do i define that and add that in I guess
Yes, you have 2 options
- Did you watch the video? if so then you should be able to group your regions
- Download this file into your model and link the table to your Elite table at the State code
- https://github.com/cphalpert/census-regions/blob/master/us%20census%20bureau%20regions%20and%20divisions.csv