I am trying to make the filters independent of each other, when in one select "-none-" that only appear filtered with a single dropdown, in this case they have to be related to the 2 to show the search, otherwise it will not show anything
Go to Solution.
I am assuming you need a condition where is None is selected then avoid that filter
If this is the case then use the following :
GroupBy(Filter(OrdenesAbiertas2,(Dropdown1.SelectedText.Value in CLIENTE || If(Dropdown1.SelectedText.Value = "-none-",true,false)),(Dropdown3.SelectedText.Value in VENDEDOR || If(Dropdown3.SelectedText.Value = "-none-",true,false)),TextSearchBox1.Text in 'OC CLIENTE'),"OC_x0020_CLIENTE","Ordendeventa")
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
View solution in original post
Hi @DavidGarcia1 ,
I have made a test on my side, please consider take a try to modify your formula as below (set the Items property of the Gallery to following😞
Dropdown1.SelectedText.Value = "-none-",
Dropdown1.SelectedText.Value in CLIENTE
Dropdown3.SelectedText.Value = "-none-",
Dropdown3.SelectedText.Value in VENDEDOR
TextSearchBox1.Text in 'OC CLIENTE'
Please take a try with above solution, check if the issue is solved.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand