Forum Discussion

CorySOAH's avatar
CorySOAH
New Member
1 year ago
Solved

Power BI Dashboard - Percentage Column in Matrix Help

Hello!   I'm creating a dashboard that shows the amount of time employees spend on tasks. I would like to add a column to the dashboard matrix that shows the percent of time spent on each task/code...
Need Help
  • Praful_Potphode's avatar
    Praful_Potphode
    1 year ago

    Hi CorySOAH ,

     you can create a visual calculations to acheive this based on the output you want.to create a visual calcuation select the matrix visual,click on New Visual Calculations button under Home tab and create calulations below:

    Percent of parent = FORMAT(
    DIVIDE(
        [Sum of Time],
        SUMX(
            WINDOW(
                1,ABS,-1,ABS,ROWS,PARTITIONBY([Name])),[Sum of Time])
    ,0)
    ,"0.00%")

    The above calculation output looks like below:

    As shown above , it will show the percentage of time spent by a user(if all entries  are added for user Kelly,Jane it will sum up to 100 %)

     

    Please mark answer as resolved once confirmed.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi CorySOAH,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to lbendlin and Praful_Potphode   for prompt and helpful response.

 

Just following up to see if the Response provided by community member were helpful in addressing the issue.

If one of the response helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar