Visual Interactions not working properly

[Oblomov]

Hello everyone,

I have a table which divides my data into three geographic regions, and a pie chart that categorizes it according to industry sector.  I want to be able to click on a region in the table and highlight the pie chart accordingly.

However, it is only highlighting the pie chart for two of the the three regions; when I select the third region, the pie chart is replaced by one that contains ONLY the data for that particular region.  

For example: when I click on US, the pie chart highlights correctly:

However, when I click on Europe, the entire pie chart changes to represent ONLY Europe (ie, the pie chart is no longer the sum of Asia, Europe and the US):

Any ideas why this might be happening?  This is a very simple model consisting of only one file (ie, no relationships between multiple files at all). 

Thanks for all replies!

[parry2k]

Is there any visual level filter on your pie chart?

[Oblomov]

No, I have selected all for both Market Value and Sector.

[v-huizhn-msft]

Hi @Oblomov,

It'd hard to check reason caused the result without sample table, do you mind share your sample table by private for further analysis?

Thanks,
Angelia

[Oblomov]

Apologies for the delayed response...I may have figured out what is causing this (it was easier to see when I changed the pie chart to a table).  Other Net Assets is negative for Asia and the US, but positive for Europe, so when I select Europe, it is adding an additional "slice" to the pie chart.  The sum of Other Net Assets for all three regions is negative, so I suppose it is being left off of the total pie chart, as well as the Asia-only and US-only pie charts.  I scaled down the data to account for the negative values (in order to preserve the total net values) and now the pie chart is functioning correctly.  Thanks to everyone who took the time to reply.

[parry2k]

interesting, do you have any measure which you are using to show value?

I assumed both the visuals are from same table