Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Setting Pie Chart control in vertical Gallery

Like (1) ShareShare
ReportReport
Posted on 4 Sep 2024 18:47:18 by 107
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:
  • CP-23071818-0 Profile Picture
    CP-23071818-0 107 on 06 Sep 2024 at 15:49:31
    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 1,545 on 06 Sep 2024 at 14:06:42
    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 107 on 06 Sep 2024 at 12:41:14
    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 1,545 on 05 Sep 2024 at 16:13:03
    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,696

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,456

Leaderboard