Pie chart remove 0 values and only show chart on selection

[ms999]

Is there a way to display pie chart data to only show the selection. E.g below are a list of bookings for a doctor. I do not want to see the zero pie slices.  

[Jamie_Scott]

On the filter pane, for your values field, select show where value > 0 

[ms999]

tried that and '1' but still shows all the 0 pie slices 

[Jamie_Scott]

Could you check that you don't have "show items with no data" selected? 

[ms999]

Do not have that option on the values field

and not selected on legend