cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## Pie chart gives wrong results

I have a calculation

% of ontime =
VAR _Prc =
DIVIDE (
CALCULATE (
[CountOfOrders],
'table'[status] = "Ontime"
),
[CountOfOrders],
0
)
RETURN
IF ( _Prc = BLANK (), 0, _Prc )

and a pie chart where I've put Status as legend and CountOfOrders and value, went into detailed labels and choose datevalue, percentage. and the distribution is bad! Integers are okay but % not 2640/4088 is 64.58%, not 57,57%. My goal is to align the KPI with % of OnTime with percentages on a chart, and keep integers values as well. If I go to CountOfOrders and "show as grand total" the % are good, but in the tooltip it shows % on data value. Is there a way? Filter context is the same

2 REPLIES 2
Regular Visitor

I have this issue also.  What I find is that if you count the unique values of the Status, that is the total the pie chart is calculating against, not the number of orders.

For example, if I had the following:

 order# Status 123 A 123 B 456 A

I would calculate the denominator as the distinct count unique order = 2 and expect %A = #A / 2

The pie chart is calculating the denominator as the count of Status = 3 and then #A/3

Hope that makes sense.

Super User

Hello,

From what I see you have more than 4088 orders in your piechart (2640 + 1035 + 911 = 4586), that's why your percentage is not the same (2640 / 4586 = 57.5%) as in the KPI. Are you sure you do not have different filters applied on your KPI and your pie chart?