A strange scenarion in BI Answer

Question

Hello Experts,

I am facing one very strange situation and I am not able to explain why:

in Snapshot month at analysis I see only 3 values:

However there are 5 values in this table, please not that I have not applied any filter:

If I select one more column then I see all 5 values at analysis:

I am surprised and clue less why column snapshot shows only 3 values when selected alone.

Sangeeta Pandey · Answer

Thanks Robert,

It is already cleared as per below screenshot- Bypass cache is disabled.

Robert Angel · Answer

On testing you might want to look to the advanced tab and clear the option that uses cache, it can save a lot of this kind of pain.

Sangeeta Pandey · Answer

I got the answer and sharing with hope that it may be useful for others with similar issue:

I need to click on refresh as below circled: