Forum Discussion

akshah's avatar
akshah
Frequent Visitor
8 years ago
Solved

pie chart remaining values

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...
General Comment
Need Help
Tips and Tricks
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    akshah,

     

    You may add a calculated table.

    Table =
UNION (
    Table1,
    ROW ( "Buildings Type", "remaining", "Value", 100 - SUM ( Table1[Value] ) )
)
akshah's avatar
akshah
Frequent Visitor
8 years ago

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's avatar
v-chuncz-msft
Community Support
8 years ago

akshah,

 

You may add a calculated table.

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