1

I have a list that has a choice field that shows 'pending', 'active' and 'closed'. Is there a way to show the count of an item based on those attributes in a Power Apps pie chart? Do I need to create two lists and use a lookup column?

  • Give some more information about your list schema. What to show in x&y axis... or d you want to show the count of Pending, active, closed in chart?? – little_big_thoughts Jan 10 '18 at 5:34
  • @little_big_thoughts normally i want to use a pie chart that show three section,that is active,close,pending and there count. – Keshav Taurah Jan 10 '18 at 5:36
4

Use below formula in PieChart->Items

Table(
    {Col: "Open", Value: CountRows(Filter(Issues, Issue_x0020_Status.Value = "Open"))
    },
    {Col: "Rejected", Value: CountRows(Filter(Issues, Issue_x0020_Status.Value = "Rejected"))
    },
    {Col: "Closed", Value: CountRows(Filter(Issues, Issue_x0020_Status.Value = "Closed"))
    },
    {Col: "In-Progress", Value: CountRows(Filter(Issues, Issue_x0020_Status.Value = "In-Progress"))
    }
)

enter image description here

Sample formula applies for column chart & line chart.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.