Column chart based on 2 choice columns

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi!

I currently have a PowerApps linked to a SharePoint List, with 2 choice columns. I need to create a column chart of counts for combinations of these choices, how do i do it?

Thanks for any help in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Could you give a sample chart you want?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi! The column chart shown below is what i am looking to get. So it will be a presentation of the counts of each combination of choices. Thank you!

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I made a sample for you.

AddColumns(GroupBy(AddColumns(LIST315,"temp",$"{'Choice[1]'.Value}&{'Choice[2]'.Value}"),"temp","temp2"),"Count",CountRows(ThisRecord.temp2))

Best Regards,

Wearsky

Was this reply helpful? Yes No