cancel
Showing results for
Did you mean:  Helper I

## Visualization Help - Show Proportions in Pie Chart & Percent Value

Hello PowerBI Community!

I really need help with creating this additional visualization that I was stuck with for quite a long time.

Here is a mock-up dataset: (Column A has all 7 days)

 Column A Column B Column C Monday John 200 Tuesday Steve 400 Monday Clive 600 Tuesday Austin 1000 Tuesday John 900 Saturday Clive 1100 Monday John 1200

What I did was to create a Card Visualization that shows the total count of column C as well as 2 different filter slicers that gives me a list of the 7 days in a week and a list of the individuals in the dataset.

What I need to do is to create a pie/donut chart as well as a percent value (something like a card) that shows the proportion of column C's value when I click on the list in my filter slicer.

For example, if I clicked on Monday, it will give me a total of (200+600+1200/Total of Column C) = 37%.

If I clicked on Monday & John, it will give me (200+1200/Total of Column C) = 26%.

The pie/donut chart will 37% of it shaded in another color.

I really appreciate any help! Thank you so much !!

1 ACCEPTED SOLUTION  Super User

@lwklwk98

Pie or Donut chart will not show the shaded area in another color. you can use the Guage chart effectively
Measure:

``````Percent =
DIVIDE(
SUM(Table6[Column C]),
CALCULATE(
SUM(Table6[Column C]),
REMOVEFILTERS(table6)
)
)`````` Did I answer your question? Mark my post as a solution! and hit thumbs up
6 REPLIES 6  Super User

@lwklwk98

Pie or Donut chart will not show the shaded area in another color. you can use the Guage chart effectively
Measure:

``````Percent =
DIVIDE(
SUM(Table6[Column C]),
CALCULATE(
SUM(Table6[Column C]),
REMOVEFILTERS(table6)
)
)`````` Did I answer your question? Mark my post as a solution! and hit thumbs up  Helper I

Thank you so much! The Guage Chart is the perfect icing on the cake 🙂  Super User

Hi @lwklwk98 ,

You can create a measure like this to get the desired result:

`Proportion% = DIVIDE(sum('Table'[Column C]),CALCULATE(sum('Table'[Column C]),ALL('Table')),BLANK())` Appreciate a Kudos 😀  Helper I

Thank you so much! I have learned something from you!  Super User

@lwklwk98 , Try a measure like

divide(sum(Table[Columnc]), calculate(sum(Table[Columnc]), all(Table)))

or

divide(sum(Table[Columnc]), calculate(sum(Table[Columnc]), allselected(Table)))

Proud to be a Super User!  Helper I

Thank you so much! That is easy to understand.  