Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Building Power Apps / Setting Pie Chart cont...
Building Power Apps
Suggested answer

Setting Pie Chart control in vertical Gallery

(1) ShareShare
ReportReport
Posted on by CP-23071818-0 101
Pie chart controls is something completely new to me in Powerapps so i apologize if i neglect any information you might need to provide an answer so here goes
 
in doing internet research I saw examples where a pie chart control was inserted into a vertical gallery. but I couldn't wrap my mind around how they changed the Items to achieve counts but it also appears that I have to count Yes / No or Boolean(0) and Boolean (1) values in the column of data i want to count. Goal is i need a Simple pie chart for each Eci_ID where it is counting each Yes's and nos in Completed column for all the child records made with that ECI_ID. 
below is a sketch of the table structure and my image of the results
 
 
here is my current rough draft. Edit: I changed the picture, Items Property of the Piechart: 
Filter(ECI_Dies_1, eci_id=ThisItem.field_0)
I set the Label property to Completed column and the series property to the Dienum column.
(dienum is what makes each ECI_ID child record a unique record) 
 
Its representing the die number which is a number (but could be a letter) as the size of the pie and adding the value 
of completed column in the label. 
What would I change the Item property to COUNT the trues vs falses to where i just 2 slices max on any chart?
 
 
Categories:
General Questions
  • CP-23071818-0 Profile Picture
    CP-23071818-0 101 on at
    Setting Pie Chart control in vertical Gallery
    it does i got it to work and looks alot better thank you
     
    For some reason When I check "does this answer your question?" it pinwheels endlessly so your first reply is the answer.
     
    Thank you for your support
  • Suggested answer
    Nandit Profile Picture
    Nandit 304 on at
    Setting Pie Chart control in vertical Gallery
     
    The "Progress Bar" control is part of modern controls and themes. If you're not able to find it, you will need to first enable it from the settings - 
     
    Once done you should be able to find it in your Controls list. 
     
    Hope this helps. 
     
    Thanks & regards, 
    Nandit 
     
    If this answers your query, please mark this response as the answer.
    If its helpful, please leave a like. Thanks!
  • CP-23071818-0 Profile Picture
    CP-23071818-0 101 on at
    Setting Pie Chart control in vertical Gallery
    Actually I really like your idea, one issue I am having is also hieght of the item of the gallery to accomodate the pie chart AND the words and this might actually fit. 
     
    i was initially trying to represent a classic automotive Pie Status symbol that is used in the current excel format (alt+0210 to 0214)
     
    bar graph may actually allow it to fit ill give it a go so you dont have to work on the pie chart!

    so which control would i select for progress bar? I tried searching for "progress" and "bar" and saw no insertable items
  • Suggested answer
    Nandit Profile Picture
    Nandit 304 on at
    Setting Pie Chart control in vertical Gallery
     
    How about you use a Progress Bar instead?
    Progress Bar Value:
    CountRows(
    Filter(
        ECI_Dies_1,
        eci_id = ThisItem.eci_id && Completed = "Yes"
    )
)
    Max Value:
    CountRows(
    Filter(
        ECI_Dies_1,
        eci_id = ThisItem.eci_id
    )
)
    Text Label
    CountRows(
    Filter(
        ECI_Dies_1,
        eci_id = ThisItem.eci_id && Completed = "Yes"
    )
) & "/" & CountRows(
    Filter(
        Tests,
        eci_id = ThisItem.eci_id
    )
)
    I will give your Pie Chart Items a go as well to see if I can come up with something. 
     
    I hope this helps. 
     
    Kind regards,
    Nandit
     
    If this answers your query, please mark this response as the answer.
    If its helpful, please leave a like. Thanks!

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update 9/9/24…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,690

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard

Featured topics

Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans