Forum Discussion

Oblomov's avatar
Oblomov
Frequent Visitor
8 years ago

Visual Interactions not working properly

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 th...
Oblomov's avatar
Oblomov
Frequent Visitor
8 years ago

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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

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's avatar
    Oblomov
    Frequent Visitor
    8 years ago

    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.