Inconsistent values in visuals

[Anonymous]

I have 3 different visuals that do not show the consitent information.

The table shows the data I am trying to represent in a doughnut chart and a card.  The values in the table are correct, but PBI does not pick up the correct values in the visuals.

The doughnut chart should have about 2/3 of the chart in the color association with the Prod by CE and 1/3 in the color associated with the MissedGoal. Instead, the chart is showing 3.

The card for the exceeded goal shows 100% instead of the correct 66.7%.

I would appreciate any assistance in resolving.

[Anonymous]

My screen shot was removed.  

My table:

Prod by CE  MissedGoal  Deployed ExceedGoal%

        2                   1                3                66.7

Card with ExceedGoal% shows 100%

DoughnutChart with Prod by CE and MissedGoal shows 1 ring with color associated with Prod By CE at 3 (100%).

Added the screenshot again, just in case.

[bheepatel]

Can you click on the doughnut chart and show its properties? Similarly, can you do the same for the KPI card?

[Anonymous]

Sorry, I thought you would be able to see the fields from the headings in the visuals.

New info.  If I have Prod by CE, MissedGoal, and ExceedGoal% in the same table, I get the correct results.    Please see the 3 tables at the bottom of the image.  If the fields are in separate tables, different results are displayed.

[Anonymous]

A little more to the mystery.  Two tables, same field, two results.

[Anonymous · Accepted solution]

Closing this thread as I feel the problem is with a measure.

[v-lili6-msft]

hi  @Anonymous 

"Closing this thread as I feel the problem is with a measure."

Great! If you consider this issue closed, please mark it as "solved". Thanks.

Regards,

Lin