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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.