Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a calculation
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.
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
96 | |
87 | |
68 |
User | Count |
---|---|
169 | |
133 | |
130 | |
103 | |
95 |