cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Filter in graphics

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.

4 REPLIES 4
KrishnaV
Community Champion
Community Champion

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.

 



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,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a THUMS-UP and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

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
Community Support
Community Support

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 

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?

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,250)