Pie Chart Colors

Hello everyone,

I have some design problems. I have a data feed with 9 columns: date, 3 text col and 5 num cols.

This feed takes information from 2 xls files and then concatenate them. So, what's the problem? :) There is one day, let's call it X-day, which exists just in one xls. I mean, that there is no 4 rows for each day, as usual. Just 1 row in feed.

Pie chart displays this feed, and if initial date is X-day (I need exactly this variant. The initial date - must be X-day) - pie chart turns blue, because of 1 row and 100% result. After switching the date - every piece of pie chart - turns blue.

But, if i choose as initial date: No Selection - Everything will work as designed.

So, i've got a question, how can i fix this without using: No selection?

Thanks,

Vitaliy.