Visualization Help - Show Proportions in Pie Chart & Percent Value

[lwklwk98]

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

[Fowmy · Accepted solution]

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

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

[jaideepnema]

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]

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

[amitchandak]

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

Thank you so much! That is easy to understand.