Getting an SSRS map to include 0 in data

51 views Asked by At

I've been working a lot with maps in SSRS recently and can't seem to find a way to set a visualization to include a 0 value in the Field to Visualize area. Has anyone found a way to include 0 so the legend reflects nothing is in a certain area on the map layer?

1

There are 1 answers

0
SQLHound On BEST ANSWER

I found the answer and I brought some props! It turns out if you look in the map layers in whichever layer you are setting, there's an option in the drop down called yourLayer Color Rule. enter image description here Once selected, If you click on distribution you can change the distribution options from 'Optimal' to 'Custom' and then select the ranges you want your legend and map to use. enter image description here

I hope this helps other SSRS users to get the visualization set properly. Thanks to William Weber for pointing me in the right direction.