Filter in graphics

[alessandramaced]

Hi

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.

[KrishnaV]

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.

[alessandramaced]

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.

[v-siky-msft]

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 

[alessandramaced]

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?