Forum Discussion

lwklwk98's avatar
lwklwk98
Icon for Helper I rankHelper I
5 years ago
Solved

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

 

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

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

     

6 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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

    • lwklwk98's avatar
      lwklwk98
      Icon for Helper I rankHelper I
      5 years ago

      Thank you so much! That is easy to understand.

  • jaideepnema's avatar
    jaideepnema
    Icon for Solution Sage rankSolution Sage
    5 years ago

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

     

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

    Appreciate a Kudos ğŸ˜€

     

    • lwklwk98's avatar
      lwklwk98
      Icon for Helper I rankHelper I
      5 years ago

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

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

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

     

    • lwklwk98's avatar
      lwklwk98
      Icon for Helper I rankHelper I
      5 years ago

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