Power BI Dashboard - Percentage Column in Matrix Help

[CorySOAH]

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 by an employee. The issue I am having is that when the page is filtered by fiscal year the sum of time changes and I am unable to solve this with the queries. Is there a way I can structure a measure to accomplish this? Any help would be appreciated, thank you!

[Ashish_Mathur]

Hi,

Explore visual calculations.

[v-pgoloju]

Hi @CorySOAH,

Just following up to see if the Response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[v-pgoloju]

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

[Praful_Potphode · Accepted solution]

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.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...