Answered

Send filtered data from several dropdowns result to chart

(0) Share

Report

Posted on by RikarHV

Hello,

I have created an app in which I obtain a "CountRows" result from an excel table in which I use several filters (chosen from several dropdowns). The filter works OK, and I can get the "CountRows" in a label (as you can see in the attached screenshot (the upper right label that marks "4")). My question is... Can I send this result to a chart in which these result appears as a column? Can these results appear grouped by different column headers (which are the dropdown columns that are loaded in the dropdowns).

If it helps, this is the formula I am using for the filters (this works OK):
CountRows(Filter(DatosIniciativas;(IsBlank(DropTipoIni.Selected.Result) ||'Tipo Revisado'=DropTipoIni.Selected.Result) &&
(IsBlank(DropSector.Selected.Result) || 'Sector objetivo'=DropSector.Selected.Result) &&
(IsBlank(DropTipoBenef.Selected.Result) || Beneficiarios=DropTipoBenef.Selected.Result) &&
(IsBlank(DropDepart.Selected.Result) || Departamento=DropDepart.Selected.Result) &&
(IsBlank(DropVicecons.Selected.Result) || Viceconsejería=DropVicecons.Selected.Result)))

Thanks in advance, power apps community!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WiZey 3,023 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hello @RikarHV ,

How about something like this?

Table( { Text:"Tipo Iniciativa"; Value:CountRows( Filter( DatosIniciativas; 'Tipo Revisado'=DropTipoIni.Selected.Result ) ) }; { Text:"Sector Objetivo"; Value:CountRows( Filter( DatosIniciativas; 'Sector objetivo'=DropSector.Selected.Result ) ) }; { Text:"Tipo Beneficiario"; Value:CountRows( Filter( DatosIniciativas; 'Tipo Beneficiaro'=DropTipoBenef.Selected.Result ) ) } )

Don't forget to rearrange your graph so it correctly displays "Text" as label and "Value" as numbers.

Was this reply helpful? Yes No
RikarHV 12 on at

Like (0)

Report
Copy link

Link copied!

Hey Wizey,
Thanks a lot!!! This helped a lot. I transformed a bit your code to enter some filters and it works like a charm, but I obtain a single column; could it be possible to group the obtained data by the values of an aditional dropdown with fields that would match the dropdown field names in the left?
For example: If with your code in the chart I obtain a "4 count" value column, I would like to "GroupBy" these results, let's say for "Department" and obtain two colums of, for instance "Department A" and "Department B" each with their corresponding count (of course the sum of both would be 4). The "Department" list values would be in an aditional dropdown or in any other variable.

This is the code I have now:
Table(
{Text:"Tipo Iniciativa";
Value:CountRows(Filter(DatosIniciativas;
(IsBlank(DropTipoIni.Selected.Result) ||'Tipo Revisado'=DropTipoIni.Selected.Result) &&
(IsBlank(DropSector.Selected.Result) || 'Sector objetivo'=DropSector.Selected.Result)
)
)
}
)

Thanks a lot in advance!!!

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (1)

Report
Copy link

Link copied!
It should be possible, although your explanation was a bit confusing so I'm not really sure how to give advice here.

You can group them, but keep in mind "GroupBy()" will return a table inside the grouped column so if you want the sum of the "CountRows()" you can use the example below:

GroupBy( source, "columnName", "groupName" ) ... Sum( "groupName", columnToSum )

Hope this was helpful to you.

Was this reply helpful? Yes No
RikarHV 12 on at

Like (0)

Report
Copy link

Link copied!

Yeah, it's a bit messy to explain, but this you sent will help for sure.
Thanks a lot for your advice!

Was this reply helpful? Yes No