Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I'm a bit new to Power Bi and have been struggling to find a way to correct the percentage of row totals going over 100% as in the below matrix:
The table data looks like this, with the value field in the Matrix being set to a count of the "Ticket ID" column one of which is showing the value as a percentage of the row total
Table name is 'Data'
Ticket ID | Date Closed | SLA State |
1 | 05/07/2018 | Within SLA |
2 | 06/07/2018 | Breached SLA |
3 | 07/07/2018 | Breached SLA |
4 | 08/07/2018 | Within SLA |
5 | 09/07/2018 | Within SLA |
Have looked around the forum but unable to find anything that works, any advice would be appreciated
Many Thanks,
Tom
I have a gantt chart and a column named completed percent limited where the values range between 0 to 100. But when I plot a gantt chart by adding the completed percent limited column to tooltip, I can see that the values exceed 100. Can someone explain me how to resolve this issue?
Hi, did you ever find a solution for this? I'm facing the same issue. Thanks!
That looks for all the world like a rounding problem if I understand what you are saying. Try increasing the decimal places to 2 digits?
Thanks for your response, i adjusted the number of decimal places but the percentage totals still don't add up to 100% (i.e. July is 88.95% + 11.72% = 100.67%)
Many Thanks,
Tom
Hi @Tom_,
Hmm, weird. Is the % a self made measure, or did you create it by "show value as: percent of row total"?
If it is a measure, could you share the dax formula?
Koen
Hi Koen,
I was using the "show value as: percent of row total", however I just changed the count (distinct) to a normal count and it all adds up to 100% for some reason. All of the columns were set to Count (Distinct) as there were a few instances where dupes appeared in the data where a case has been reopened.
Many Thanks,
Tom
I can confirm, I ran into the same issue and I was counting distinct values. Once I changed it to just count, it totaled correctly.
I would like to know why distinct count doesnt work with the percent of row function. It doesnt make sense that it will add up to be more than a 100%, and it even displays the total as 100% when its actualy 102.xx%
Hi @tom_,
This looks like a rounding issue. I would change the number of decimals in the format pane of the visual.
User | Count |
---|---|
91 | |
77 | |
71 | |
64 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
61 |