Forum Discussion
Modelling Custom Geographical Regions for Map Visual
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.
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.
Thanks Ashish, really appreciate the help. I was able to split the data into rows, but the visuals still aren't working properly.
After splitting into rows:
After Splitting into Rows
Map visual with no slicer selections:
Map with no slicer selection
Map with Japan selected in slicer. The number of projects for Japan should be 4, not 1.
Slicer with Japan selected - the number of projects for Japan should be 4, not 1.
You are welcome. In the Query Editor column, right click on the Region column and trim the extra spaces.
This worked! The rows needed to be trimmed, as you said. Thank you
