Issue with Single Selection Slicer Filter another Slicer

Hi,

I'm having trouble making my single-selection slicer filter another slicer. Both slicers are from the same table, but I want column2 slicer to only show O1, O2, O3, and O4 when I select Orange in the first slicer. Currently, when I select Orange, the second slicer doesn't update properly. It stays at one of the values listed under the previous column 1 selection.

Is it possible to make the column 2 slicer change dynamically or select the relevant value by default once the selected value in column 1 changes?

Sample dataset.

Single selection slicer with Column1 and Column2

When I select to Orange from Apple in Column1 slicer, value in Column2 should change to a default value listed under Orange, but it persist on the previous selected values. Is there anyway to fix this or workaround it? 

 

Expected outcome:

edit: attached PBIX as sample file, add table format dataset.
BI_Slicer Issue.pbix 

Thanks in advance!