Answered

Dropdown within Column Chart

(0) Share

Report

Posted on by ReyOrtiz

146

Hi everyone,
Hope you all are doing well, I need some assistance with PowerApps specifically with charts. I have a list that I want to create a chart based on 2 columns. one column is called territory (North, South, West, and East) And I want those options to be on a dropdown, so when a territory is chosen the chart shows the issue categories from the other column. I tried and it comes back with all answers per territory instead of grouping them into the 5 categories that they are. For example, if I select North, I wanted to come back on the chart with issue1=# issue2=# issue3=#, etc. I searched around the site and could find anything that will help me add the answers per issue and present a column on the chart. So far, I tried the following,

Sort(Filter(CETroubleshooting_tracker,Territory = Dropdown5.Selected.Result),Category)

for the chart and
Distinct(CETroubleshooting_tracker, Territory) for the dropdown (this one is working fine)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Ginko 221 on at

Like (0)

Report

Will these issues be static and predefined or be consistently changing/added/removed with user input?

Was this reply helpful? Yes No
Verified answer

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (1)

Report
hi there @ReyOrtiz

what does the data look like in the second column? you will have to group the data and based on what you have in the second column either sum or count the data.

for example

AddColumns( GroupBy( yourDataSource, "territory", "territories" ), "total for issue1", Sum( territories, issue1 ), "total for issue2", Sum( territories, issue2 ), "total for issue3", Sum( territories, issue3 ) )

this will give you the total for issue1, 2 and 3

If you have a column which is populated issue 1 issue 2/3 then

AddColumns( GroupBy( Filter(yourDataSource, territory = yourComboBox.Selected.Result), "territory", "territories" ), "total issue 1", CountRows( Filter( territories, issues = "issue 1" ) ), "total issue 2", CountRows( Filter( territories, issues = "issue 2" ) ), "total issue 3", CountRows( Filter( territories, issues = "issue 3" ) ) )

Result

Hope it helps,

R

Was this reply helpful? Yes No
ReyOrtiz 146 on at

Like (1)

Report

Thank you @rubin_boer
It worked like a charm thank you so much for the quick response.

Was this reply helpful? Yes No