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!
