cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
venka91
Super User
Super User

Pie chart for priority column

Hi there,

 

Need a help in configuring the pie chart. I have sharepoint list column by name Priority and Category for a helpdesk app. Priority is a choice column with "high", "low". "Medium". And Catergory is a column with "Printer","Network","PC"

 

Now i want to make two pie charts for priority and category. These two columns not appearing in the advanced property of Pie chart.

Also, how to i make this column visible in pier chart property and populate values in chart. Please help.

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @venka91 ,

 

I did a demo for you.

1\ This is my list.

vxiaochenmsft_0-1629860351783.png

 

2\ Add a pie chart and set its Items property to:

AddColumns(GroupBy(AddColumns(LIST159,"Text_Priority",Priority.Value),"Text_Priority","OtherColumns"),"Number",CountRows(OtherColumns))

vxiaochenmsft_1-1629860388267.png

 

3\ The result is as follows:

vxiaochenmsft_2-1629860403054.png

 

Best Regards,

Wearsky

 

 

 

View solution in original post

1 REPLY 1
v-xiaochen-msft
Community Support
Community Support

Hi @venka91 ,

 

I did a demo for you.

1\ This is my list.

vxiaochenmsft_0-1629860351783.png

 

2\ Add a pie chart and set its Items property to:

AddColumns(GroupBy(AddColumns(LIST159,"Text_Priority",Priority.Value),"Text_Priority","OtherColumns"),"Number",CountRows(OtherColumns))

vxiaochenmsft_1-1629860388267.png

 

3\ The result is as follows:

vxiaochenmsft_2-1629860403054.png

 

Best Regards,

Wearsky

 

 

 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,474)