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...
I agree with parry2k , you first need to define the concept of regions, nothing that indicates in your file.
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
that file should be correct, the chart on region is killing me, not sure how to make it show by region with the states that are actually in the region. last thing, can you explain how to do the correct formula for the percent change in the pf elite tab. it showss variance number only but i wanna try to get percent in it,
wont let me PM. I was only working with the elite files, thats what i needed to see the visuals i have. v