Getting my data broken down by states?

[bv27718n]

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 trying but feeling awful that I cant get it. 

[aj1973]

Where did you add the regions in this file???

[bv27718n]

but i dont get how to basically drill down in the region in the region tab to be able show ok, this region and you can see the states listed. it only shows region. i tried doing a new group called west, with only those states but it still only will show the region, why is that?

[bv27718n]

https://doc-04-1s-docs.googleusercontent.com/docs/securesc/o5p4qtjd3e4qgqsh90ir7pkkjs90l883/r5oouhfa...

[aj1973 · Accepted solution]

[bv27718n]

https://drive.google.com/file/d/1ZvLbRQEltYv4i3hbo_EdA94c_IVqv4yW/view?usp=sharing

[bv27718n]

for emaple it will show the states of the region i select in the charts but it only highlights them against the other states, shouldnt it show just those states?

[aj1973]

[bv27718n]

hi sorry wrong file it is 7.8 the groups are there in the file now

My Drive - Google Drive

[bv27718n]

and how do you pull the table in then i should get it i think

[bv27718n]

https://drive.google.com/file/d/1ORC3CBflyiRQW_CKBXVemPtRDyItTDQ9/view?usp=sharing that link has the file 7.8.2021/ im going crzy feel like crying haha

[aj1973]

Just do it this way, it's easier and faster for you. Follow the table from Github or anywhere on the net.

[aj1973]

Hi @bv27718n 

Group the state by regions : select the field of the states and create a new group

[parry2k]

@bv27718n do you have region data in your model?

[bv27718n]

Hi! 

No I dont, it is a column of stats only, how can I do that? So confused. 

[aj1973]

Follow this video

https://www.youtube.com/watch?v=D1LO8syugMA

[bv27718n]

feel like im going to break down

[aj1973]

You are making me lol which is good but still access denied.

[bv27718n]

doc is available, thank you so much. im so lost

[bv27718n]

it is all set now 

[bv27718n]

I get it wont work, I just was not sure what or how too pull regions into it to break that down into it further.