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...
parry2k's avatar
parry2k
Super User
8 years ago

Is there any visual level filter on your pie chart?

  • Oblomov's avatar
    Oblomov
    Frequent Visitor
    8 years ago

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

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

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

       

      I assumed both the visuals are from same table

    • 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.