Display Percentage complete of project (Individual Row)

[longah]

Hello,

I have a column in a database that has the value of percentage complete for a phase of the project.

I would like to have a donut graph for each phase that show the percentage complete. It needs to be a donut graph that only displays the percentage of a single row's value.

I need to build a mechanism that only filters on a single project (row) and then displays this percentage complete.


We are trying to move away from excel into powerBI so any suggestions would be well received!

Thanks

[v-alq-msft · Accepted solution]

Hi, @longah 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create two measures as below.

Complete Rate = 
SUMX(
    SUMMARIZE(
        DISTINCT('Table'[Project Name]),
        'Table'[Project Name],
        "Result",
        DIVIDE(
            SUM('Table'[Bid Phase Percent Complete])+
            SUM('Table'[Engineering Phase Percent Complete])+
            SUM('Table'[Furnishing Phase Percent Complete])+
            SUM('Table'[Construction Phase Percent Complete])+
            SUM('Table'[Pro - Services Phase Percent Complete])+
            SUM('Table'[Close Out Phase Percent Complete]),
            6
        )
    ),
    [Result]
)

InComplete Rate = 
SUMX(
    SUMMARIZE(
        DISTINCT('Table'[Project Name]),
        'Table'[Project Name],
        "Result",
        1-
        DIVIDE(
            SUM('Table'[Bid Phase Percent Complete])+
            SUM('Table'[Engineering Phase Percent Complete])+
            SUM('Table'[Furnishing Phase Percent Complete])+
            SUM('Table'[Construction Phase Percent Complete])+
            SUM('Table'[Pro - Services Phase Percent Complete])+
            SUM('Table'[Close Out Phase Percent Complete]),
            6
        )
    ),
    [Result]
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[longah]

This isn't EXACTLY what I needed but the fundamentals you cover here are extremely helpful!!

Thank you!

[longah]

Column Name : Row Value

Project Name: Pxxx

Bid Phase Percent Complete: 100%

Engineering Phase Percent Complete: 80%

Furnishing Phase Percent Complete : 0 %
Construction Phase Percent Complete: 0 %

Pro - Services Phase Percent Complete: 0 %

Close Out Phase Percent Complete : 0 %


In Power BI I would like to use the Donut graph (or other graph [Gauge]) to visualize the percentage complete for each phase.


The graphs would need to be based on the selected project name from the filters

[jairoaol]

Send some example of what you want to achieve and some values