Conditionally change the palette colour in pie chart

[syedshah]

Hello,
I have a pie chart. It shows two measures in series. One is used space and one is available space. I want that when the available space is less than 10 GB, then show the available space section in red. I have created a variable, which says that if available space is less than 10 GB then 0 else 1. I have set the conditional palette, 0 to red color.

However the problem here is that we are not seeing available space against different dimensions. The problem here is that used space and available space are two different measures, which eventually sums up into total space. Now the problem is that when available space is less than 10 GB, it makes the whole pie chart into red rather than making the available part red. I want that the used space palette stays in the same color while only the available space becomes red

Can someone please give me any solution how can i fix this. comparing two measures in the same pie chart. I am draing both used space and available space measues in the series part of pie chart

Thanks
Arif

[syedshah]

Can someone help in the above...i have tried many ways..but its not working  :(

Arif