colour interactive map based on data

Hi all,

I created a dashboard with a map of Japan that automatically visualises trends based on the data metric selected. Though, I want to keep all prefectures/provinces coloured 'black' with a white outline if there is NO data available. As an example, for the population data all prefectures have data available and should does be coloured accordingly, though, products aren't sold in all of them, thus, only the ones where data is available should be coloured. Currently it would colour them in the lightest colour (based on the legend defined)...

This is the code I am using:

Please Login or Register  to view this content.

I would assume this could be fixed with a 'simple' If statement somewhere in between the lines of code?

japan map forum.PNG

What happens if, in your dataset, you put an error value for prefectures where there are no sales? For example, type the formula

Formula:

Please Login or Register  to view this content.

I use this trick in charts where I don't want a data point plotted (Excel likes to evaluate a blank as a zero).