Forum Discussion
Non-Summerized Percentages in Matrix Visual
Hi Grimfandango227 ,
First of all, thanks Greg_Deckler for the quick reply.
According to your description, you can try creating a measure and then placing the measure on the matrix.
OT % = SUM('Table'[OT Percentage])If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Greg_Deckler ,
Thanks for the reply!
Example data as table below ↓↓
| Dept. | Reg. Hours | OT Hours | Total Hours | OT Percentage |
| Blinker | 2387.5 | 237.75 | 2619.25 | 9.08% |
| Maintenance | 148 | 0 | 148 | 0.00% |
| Shipping | 1343 | 105.75 | 1448.75 | 7.30% |
I am having trouble getting the OT percentage into my visual in powerbi. I am using the Matrix visual; the issue is that it keeps summarizing the percentages and they appear wrong.
Please note that the one aspect that is not included in my data example is that these are broken down by week. Screenshot below.
Hopefully, this made more sense. Thanks again for the help!
Jeremy
Grimfandango227 Well, it's likely using an implicit measure. You can change the implicit measure by clicking the dropdown for the column in the field well for the visual. Maybe Average is correct versus Sum.