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 IV

@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 IV

@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 🙂

Solution Specialist

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 IV

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

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors