Forum Discussion

bv27718n's avatar
bv27718n
Icon for Helper II rankHelper II
5 years ago
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...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

     

bv27718n's avatar
bv27718n
Icon for Helper II rankHelper II
5 years ago

https://drive.google.com/file/d/1xWl-pLZ3m6xinlepSwWI1j7mRxaTJjxl/view?usp=sharing

 

So I get how to group regions in for the PF elite tab, and that works great. What I dont get though is in the tap for region, I want to show by region and the states within the region, but if i do a new group it will only show region names on the x axis not state names. i tried fixing but it wont group to show that. Additionally, I am lost how to do a correct formula for pf elite, the var change. i see the number change but i want to say this is my percent change year over year. it keeps giving errors. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi bv27718n ,

 

You could add both region and state to x-axis and use drill down feature at the top right of the visual.

 

Best Regards,

Jay