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
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)
    )
)

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
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)
    )
)

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
Super User
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())

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
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)))



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.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!