Question about search. How can I search for data in Yes/No Columns?
Iโve made the column searchable. The goal is to find all rows that have False in the PAID column.
Thanks in advance
Michael
The Searchable option determines whether the column content is searchable from the search bar in the user interface. The phrasing of your question suggests youโre interested in searching from an expression instead. To search from an expressionโฆ
This will return a List containing the values of the [DesiredColumn] in MyTable for rows where [PAID] is TRUE:
select(MyTable[DesiredColumn], ([PAID] = true))
Since [PAID] is a Yes/No column, you can simplify the above slightly:
select(MyTable[DesiredColumn], [PAID])
Thanks.
I found using a slice then adding to a UX as a button at the bottom works great.
The Searchable option determines whether the column content is searchable from the search bar in the user interface. The phrasing of your question suggests youโre interested in searching from an expression instead. To search from an expressionโฆ
This will return a List containing the values of the [DesiredColumn] in MyTable for rows where [PAID] is TRUE:
select(MyTable[DesiredColumn], ([PAID] = true))
Since [PAID] is a Yes/No column, you can simplify the above slightly:
select(MyTable[DesiredColumn], [PAID])
Thanks.
I found using a slice then adding to a UX as a button at the bottom works great.
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |