Forum Discussion

bv27718n's avatar
bv27718n
Helper 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
Helper II
5 years ago

cool ,thanks but then you dont need the table no? or do i add that where

aj1973's avatar
aj1973
Community Champion
5 years ago

No don't add no table...just make sure you Goup them well

  • bv27718n's avatar
    bv27718n
    Helper II
    5 years ago

    ok cool, then I should be able to go in add visuals only for selected regions correct?

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      Yes, The Regions(the group) you can use it in visuals as well as in slicers.

      • bv27718n's avatar
        bv27718n
        Helper II
        5 years ago

        thanks for the help. Another question is, I created regions which is great, but when I go to create a group for say, west states only, it only shows the region not states. how do you rectify that?