Follow the below steps:
1. Create the bar chart as required. ( For ex. below)
2. Craete a calculted field with any constant value or create a fixed avg(measure).
3. Now add the created field in the sheet.
4. Now make a dual axis chart.
Thus in the above chart green color shows no value or zero.
Hope it helps you.