title: Excel filters change if first filtered value does not exist
body: <p><strong>Pivot Filter Name</strong>: Country_Flg, it takes 2 different value, these are 0,1. I am filtering my pivot as only <strong>Counrty_Flg=1</strong>.</p>
  <p>Under some conditions, pivot table source updates and Country_Flg takes just 0 or 1. There is no problem when the value is only 1, but when the value is only 0, my filter changes and takes <strong>Counrty_Flg=0</strong>. My dashboard is feeding on this pivot tables. So, wrong values are showing on the dashboard. Besides, when <strong>re-update</strong> the pivot source, <strong>it still remains 0</strong>.</p>
  <p>I couldn't find a way how I can anchor the value as 1 under all conditions.</p>
  <p><a href="https://i.stack.imgur.com/r2fUS.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>after source data updating, my filter value is changing because 1 doesn't exist anymore.</p>
  <p><a href="https://i.stack.imgur.com/wGiLK.png" rel="nofollow noreferrer">enter image description here</a><a href="https://i.stack.imgur.com/31KMS.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>But I don't want to filter as 0. I need that if 1 doesn't exist, pivot should not bring any value.</p>