Forum Discussion

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 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.

General Comment

Tips and Tricks

You may add a calculated table.

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

3 Replies

Hardik
Continued Contributor
8 years ago
Hey could you please share the sample data for further assistance.
- 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
    Community Support
    8 years ago
    akshah,
    
    You may add a calculated table.
    
    Table = UNION ( Table1, ROW ( "Buildings Type", "remaining", "Value", 100 - SUM ( Table1[Value] ) ) )