Forum Discussion
Non-Summerized Percentages in Matrix Visual
Hello!
I am having trouble simply showing the Percentage of Overtime hours in the Total hours worked. Every time I add to the Matrix it Summarizes the totals and it is incorrect. Screenshots below.
Please note that the column number is the week of year number and the Row headers are the departments.
Any help would be greatly appreciated.
Thanks!
Jeremy
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.
4 Replies
Grimfandango227 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.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.
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.
