Answered

Get a Pie Chart to count based on conditions in another column

(0) Share

Report

Posted on by Tim24

I have a Power App that pulls data from an excel file. I want to build a pie chart that only pulls data from one column based on another column with a "yes" in the selected cell.

I have a Pie Chart that can count the column, but I need to show this data, filtered by another column. Here is the code in "Items" and the Pie chart I have already.

AddColumns(GroupBy(Table1, "Delta / Full FAI", "DFF"), "TotalDFF", CountRows(DFF), "DFF1", Concatenate('Delta / Full FAI', " - ", Text (CountRows(DFF))))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Tim24

Can you share your data and the end result you want to get in your pie chart ?

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Tim24 5 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately I cant share the data, but I want the pie chart to show a subset of the overall data based on another column, with "Yes" or "No" in the other column. I would think it is the equivalent to a CountIf function, but I can't get it to work in Power Apps.

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi , @Tim24

Thanks for your response! This is my test data and the result:

ClearCollect(Table1Test , { 'Delta / Full FAI' : "DETLA" , Flag : "yes" }, { 'Delta / Full FAI' : "DETLA" , Flag : "yes" }, { 'Delta / Full FAI' : "DETLA" , Flag : "yes" }, { 'Delta / Full FAI' : "DETLA" , Flag : "yes" }, { 'Delta / Full FAI' : "DETLA" , Flag : "no" } , { 'Delta / Full FAI' : "FULL" , Flag : "yes" },{ 'Delta / Full FAI' : "FULL" , Flag : "no" } , { 'Delta / Full FAI' : "-" , Flag : "yes" },{ 'Delta / Full FAI' : "*" , Flag : "no" } )

My Combo box 1 -items: ["yes","no"]

I use this code in PieChart - items:

AddColumns( GroupBy(Table1Test , "Delta / Full FAI" , "DFF" ) , "TotalDFF" , CountIf( DFF ,Flag= ComboBox1.Selected.Value) , "DFF1" , Concatenate('Delta / Full FAI', " - ", CountIf( DFF ,Flag= ComboBox1.Selected.Value) ) )

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No