Filter in graphics

(0) Share

Report

Posted on by alessandramaced

308

I'm trying to put a filter in graphic.

Not working.

I'm using "Filter(QUADRO_UN;"SERVIDORES_total de cargos preenchidos" in Atributo || "TOTAL CARGO PROVIDOS PROMOTORES" in Atributo)"

I neet that a column named "Atributo" to show only values to "SERVIDORES_total de cargos preenchidos" or"TOTAL CARGO PROVIDOS PROMOTORES" .

Thanks for help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!
Hi @alessandramaced ,

Try this:
Filter(QUADRO_UN;"SERVIDORES_total de cargos preenchidos" in Concat(Atributo,Value&",") || "TOTAL CARGO PROVIDOS PROMOTORES" in Concat(Atributo,Value&","))

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
alessandramaced 308 on at

Like (0)

Report
Copy link

Link copied!

Hi

It didn't work : Filter(QUADRO_UN;"SERVIDORES_total de cargos preenchidos" in Concat(Atributo;Value&",") || "TOTAL CARGO PROVIDOS PROMOTORES" in Concat(Atributo,Value&","))

Point error in Concat(Atributo,Value) part.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @alessandramaced ,

What is the data type of Atributo column?

If it is single line of text column, there is no need to use 'in' operator in the formula, please try this:

Filter(QUADRO_UN; Atributo = "SERVIDORES_total de cargos preenchidos" || Atributo = "TOTAL CARGO PROVIDOS PROMOTORES" )

Hope this helps.

Sik

Was this reply helpful? Yes No
alessandramaced 308 on at

Like (0)

Report
Copy link

Link copied!

I think the problem is that I'm using a form with data "QUADRO_un", but my others screens has data "siteinspectorun".

I need first to correlate datas (gallery3 selected "Nome_Ua" to find "QUADRO_un" same Nome_Ua.

Then I need to filter graphic with 2 "atributo" from this "Nome_UA" in "QUADRO_un".

To complicated?

Was this reply helpful? Yes No