I am trying to put together a map that will look similar to the one in Power Bi Showcases/Regional Performance. I am looking to do “total orders” and group the states together by pod groups. Our pods are based on states. We have the North Pod, SouthEast Pod, and West Pod. I think a conditional column is the way to go but I’m not sure how to do it.
The excel sheet I am loading into the model does not have the pods in it. It just has the states as a column