Hi all. I realy need some good answers on this issue.
I have a Combobox that gets data from a SharePoint list. Now I want to filter the data only to show certain items, but everytime I try to filter on the yes/no values, I get this error:
"Incompatible type. We cannot valuate your formula because the values that are compared in the formula are not the same type".
Can anyone explain to me how to fix this? The Yes/No fields, and it seemes that no matter how I set up the filter, I can only show all the items in the combobox, or none 😞
I need somehow to change the value from Yes/no to text. If I make it as a gallery, it changes to true/false, but this is also impossible for me to filter on.
Hope anyone has some good sugestions.
Go to Solution.
View solution in original post
@mdevaney THX so much. I have not been able to find out that my self. Thanks for link to the articel 🙂
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