Selecting all values in a filter (in power Q) does not necessarily mean that you want to select all.

[MatjoCol]

I have a boolean column where the falses are very infrequent. I want to filter only showing the rows that have true and exclude those who are false. When I select true, Select All automatically gets selected because true is the only available value. In my case I am able to get more data so show false as an alternative and work around select all but i can imagine that there would be instances where it would be harder.

I would suggest that Select All does not get selected automatically when all selected options have been selected. 

Best regards,
Mattias

[v-diye-msft · Accepted solution]

Hi @MatjoCol ,

I'd like to suggest you to use the filter in report pane, rather than power Q. coz the changes made in power Q will affect the underlying data modeled in report.

If you'd like to get more data as alternatives, please use the filter in report.