SSRS Map Report - color rule & Distribution options with 0-baseline? Red-White-Green color range

Question

Hi Folks,

i try to visualize KPI-data with SSRS Maps:
- Analytical Data contains negative and positive values
- Negativ values should be displayed as polygon filled with a range of red values
- Positiv values should be displayed as polgyon filled with a range of of green values.
- Distribution of values/colors should be done by SSRS via "Optimized/Interval..Distribution Mode

So basically i want a Red-White-Green schema with the value 0 as middle/baseline applied:

I'm searching for a way to get the desired behaviour WITHOUT MANUALLY configuring bucket-ranges (Color Rules>Distribution Options>Custom)
Manually configuring the buckets is not possible because of data variety , calculating this values by code is to much work!?
Distribution Mode "Optimized" can't be configured to differentiate between negativ/positiv values or set the start/end range for the central/middle bucket..
Anyone with ideas?

Thanks,

JJ

Answer 1

addition: it seems also to be impossible to conditionally set the use of specific colors via expression. It's only possible via expression to generate a dynamic color(name) but not to activate/deactivate the color to be used?! So if i want in one case red to be used in another case not to be used... i need a duplicate card and toggle the "visible" propery by checking if MIN(data) < 0..

so for the case when we have only positiv values i use this config (map1):

and for the case the data contains negative and positive values this config (map2):

Still have problem with the "negative values" use case :(

I calculated he range_start and range_end via expression , so that start and end are always same (i.e. start: -10 , end: +10). 
But unfortunately i can't achieve with this approach a "hard centerpoint" where negative values are always red and positiv always green range..
Tried with "Equal Distribution" and with "Equal Interval" Method..

So am i really the only one which needs to insure that negative values in maps are always displayed in red?! Can't believe that ;)

Thanks for any hints!

Answer 2

To visualize business data against a geographical background, you can add a map to your report. The type of map that you select depends on what information that you want to communicate in your report. the link below that might helpful for you.
Creating Map Drill Down Reports in SSRS - SQL Server 2008 R2
Maps (Report Builder 3.0 and SSRS)

Answer 3

I'm having the exact same problem.  If I try to do a custom range I always get an error "x is invalid.  Valid values are '0' through 'x'.

Anyone else having this problem?  I'm using SQL Server 2008 R2.  Maybe this has been resolved in 2012?