pie chart remaining values

[akshah]

Dear All,

I am new to Power BI. I know it is a silly doubt but i have been trying since a lot of time. 

I have 5 rows and 2 columns the percentage of that row does not come up to 100%. 

But how can I show this in a pie? Since the total  values do not add up to 100% .I need to somehow show the  remaining. But I can't figure out how.

[Hardik]

Hey could you please share the sample data for further assistance.

[akshah]

Yes i have 

Buildings Type               Value

Rooftop                          12.6

Parking Lot                      18

Under Construction         22

Sewage plant                   14

This all does not sum upto 100.

So i want a section in PIE chart where it shows value left 100-(12.6+18+22+14)

Thanks in Advance 

[v-chuncz-msft · Accepted solution]

@akshah,

You may add a calculated table.

Table =
UNION (
    Table1,
    ROW ( "Buildings Type", "remaining", "Value", 100 - SUM ( Table1[Value] ) )
)