Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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

jaideepnema
Solution Sage
Solution Sage

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

Thank you so much! That is easy to understand.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.