Forum Discussion
Solved
Modelling Custom Geographical Regions for Map Visual
Hi, New to PowerBi and need help understanding how to model regions. I'm working on creating a report that deals with multiple projects spread over several regions. Our company has custom geo...
Hi,
In the Query Editor (where you split the Region column into multiple colukns), then is an option under Advanced to split by rows. After splitting by rows, create a relationship from the Projects to the Regions table. You should now be able to build your desired visuals.
This worked! The rows needed to be trimmed, as you said. Thank you
You are welcome.