I am now trying to work out how to add colours to my map visual to differentiate different locations in regions.
I have grouped locations by regions using a calculated field so that it can be used in a drop down menu.
for example, if i clicked ‘East Midlands’
I’d like thhat East Midlands,Derby,Leicester,Nottingham shown as different colours on the map so they can be differentiated
Below is what it looks like at the moment. I have tried adding the calculated field to the ‘colour’ well and also the orginal ‘location’ field to the ‘colour’ well but with no luck
There is an option that would change the way the user would interact with the dashboard but would achieve your goal. First, swap the order of your two fields in the color by field well so that Departments/Regions is at the top. That should immediately change the color of your regions.
When the dashboard is published the user will hover over the right corner of the visual and click on “drill down” to see the individual components of a region. The second way is to hover your mouse directly over the region on the map and the option to drill down will be there. The second option will drill down just to that specific region.
I’m pretty sure, here is the code i’ve used below :
ifelse(
{Location} = “East Yorkshire & Lincs” OR {Location} = “Humberside” OR {Location} =“Lincolnshire” , “East Yorkshire & Lincs”,
{Location} = “London” , “London”,
{Location} = “North East & Cumbria” OR {Location} =“Cumbria” OR {Location} =“Newcastle” OR {Location} =“Tees”, “North East & Cumbria”,
{Location} = “North West” OR {Location} = “Lancashire” OR {Location} =“Manchester” OR {Location} =“Merseyside”, “North West”,
{Location} = “South” OR {Location} =“Berkshire” OR {Location} =“Dorset” OR {Location} =“Hampshire & Isle of Wight” OR {Location} =“Oxfordshire”, “South”,
{Location} = “South East” OR {Location} =“Kent” OR {Location} =“Surrey” OR {Location} =“Sussex”, “South East”,
{Location} = “South West” OR {Location} = “Cornwall” OR {Location} =“Devon” OR {Location} =“Channel Islands” OR {Location} =“Jersey” OR {Location} =“Guernsey”, “South West”,
{Location} = “West” OR {Location} =“Bristol” OR {Location} =“Gloucestershire” OR {Location} =“Somerset” OR {Location} =“Wiltshire”, “West”,
{Location} = “West Midlands” OR {Location} =“Birmingham & WM” OR {Location} =“Coventry & Warwickshire” OR {Location} ="Hereford & Worcester " OR {Location} =“Shropshire” OR {Location} =“Stoke”, “West Midlands”,
{Location} = “Yorkshire” OR {Location} = “Leeds” OR {Location} =“Sheffield” OR {Location} =“York”, “Yorkshire”,
{Location} = “East Midlands” OR {Location} = “Derby” OR {Location} =“Leicester” OR {Location} =“Nottingham”, “East Midlands”,
{Location} = “East” OR {Location} = “East (Norwich)” OR {Location} =“East (Cambridge)” OR {Location} =“Cambridgeshire”
OR {Location} =“Essex” OR {Location} =“Norfolk” OR {Location} =“Northampton” OR {Location} =“Beds/Bucks/Herts” OR {Location} =“Suffolk”, “East”,“Other”)
