cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lwklwk98
Helper I
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 BColumn C
MondayJohn200
TuesdaySteve400
MondayClive600
TuesdayAustin1000
TuesdayJohn900
SaturdayClive1100
MondayJohn1200

 

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
Fowmy
Super User IV
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)
    )
)

Fowmy_0-1622631131365.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

6 REPLIES 6
Fowmy
Super User IV
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)
    )
)

Fowmy_0-1622631131365.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

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

jaideepnema
Solution Specialist
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())

jaideepnema_1-1622631105603.png

 

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

 

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

amitchandak
Super User IV
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)))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Thank you so much! That is easy to understand.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

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

R2 (Green) 768 x 460px.png

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