Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
akshah
Frequent Visitor

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.

1 ACCEPTED SOLUTION

@akshah,

 

You may add a calculated table.

Table =
UNION (
    Table1,
    ROW ( "Buildings Type", "remaining", "Value", 100 - SUM ( Table1[Value] ) )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Hardik
Continued Contributor
Continued Contributor

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

akshah
Frequent Visitor

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 

 

 

@akshah,

 

You may add a calculated table.

Table =
UNION (
    Table1,
    ROW ( "Buildings Type", "remaining", "Value", 100 - SUM ( Table1[Value] ) )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.