cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
justmeakinna Visitor
Visitor

Show value of a column as percentage of a greater value

Heey, 

 

I have a (possible) very basic question with regard to pie charts

I have two columns in my data. One has a sum of roughly 7 billion and the other a sum of 9 billion. I would like to create a pie chart with the size of the second column (9 billion) and have the first column show up as a percentage in this pie chart.

 

Thus have the pie chart show 7 billion out of the possible 9 billion coloured (roughly 77.7%)

 

I hope you guys can help me.

Thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Nathaniel_C Super Contributor
Super Contributor

Re: Show value of a column as percentage of a greater value

diffrence pie.PNG

 

 

 

 

 

 

 

@justmeakinna ,

Like this? 

 

Sum both columns, then create a measure showing difference.

Difference = [All countries] - [My country]

Use that and the col you wish to show.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

View solution in original post

1 REPLY 1
Nathaniel_C Super Contributor
Super Contributor

Re: Show value of a column as percentage of a greater value

diffrence pie.PNG

 

 

 

 

 

 

 

@justmeakinna ,

Like this? 

 

Sum both columns, then create a measure showing difference.

Difference = [All countries] - [My country]

Use that and the col you wish to show.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 217 members 2,170 guests
Please welcome our newest community members: