Forum Discussion

ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
4 years ago
Solved

power Bi Matrix-add total in same column

Hello, I have matrix -under column - SITEID-"ALBIAN" "HORIZON"  and LABORPAYCODE has lots. such as 801,802,814,809,826.... only 801 paycode represent for Regular time all other represent Overtime. I...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, ABC11 

    You can  add a new calculated column 'Lable Time' to replace your original field 'LaborPayCode' in your matrix visual.

    Lable Time = IF('Table'[LaborPayCode]=801,"1Refgular time","2Over Time")

     

    Please check my sample file for more details.

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

serpiva64's avatar
serpiva64
Icon for Solution Sage rankSolution Sage
4 years ago

Hi,

in your table you select column Laborpaycode and group it this way

and then in your visual you use the groupd column instead of Laborpaycode

 

If this post is useful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !