Multi choice column in Sharepoint List to Pie Chart

(0) Share

Report

Posted on by meinjoeskii

I have a List (Customer), inside the list there is ID, Customer Name and Product column. Product column is a multi choice option. Product Column contain these choices (PVC Marble, Foam Panel, Fluted Panel, Wainscoating, Wave Panel, PU Stone, Accessories). I want to make a Pie Chart in PowerApp. I want the Pie Chart to display Products and if it is a multi value, split the value then group. This is my current code on visible of the page.

ClearCollect(
 GroupedProductData,
 AddColumns(
 GroupBy(
 AddColumns(
 Filter(Customer, Status.Value = "Closed"),
 "ProductText",
 Product.Value 
 ),
 "ProductText",
 "Grouped4"
 ),
 "Total",
 CountRows(Grouped4)
 )
);

Problem is Product.Value can't be called out. I'm thinking the problem is due to multi-choice. Please help. Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @meinjoeskii ,

Please share the sample data and sample pie chart.

Best Regards,

Wearsky

Was this reply helpful? Yes No
meinjoeskii 19 on at

Like (0)

Report

Pie Chart

Data

Is this sufficient? Tell me if you need more info. The collection will be dropped into the Pie Chart item

Was this reply helpful? Yes No
meinjoeskii 19 on at

Like (0)

Report

Hi my guy, sorry for pinging you. But are you free to solve my problem?

Was this reply helpful? Yes No