Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am building a report that has a table with many rows and five columns. Two of the columns are a boolean true/false, and the vast majority of the rows will be false on both. The main use of the report will be to review rows where there's a mismatch - one false and the other true. Is there a way to filter/add a slicer that would show all the records where at least one of the boolean values is true?
I do have two slicers, one for each of the boolean values, but then the user has to toggle them back and forth to see what they are looking for. I don't want to filter out all the rows that are false in both values because there are some that should be true and this report is intended for the user(s) to be able to see whether the product is set up correctly.
Solved! Go to Solution.
The easiest option is probably to add a calculated column that compares the values in the two columns.
Fields Match = Table[Field1] = Table[Field2]
Then you can filer on that to = FALSE to find all those that don't match.
Hi, @Xaraja,
if I got your description right -> check whether one of the columns isTRUE:
IF('Table'[FirstCheck]=TRUE() || 'Table'[SecondCheck] = TRUE(), "Product with True", "Correct Product")
Goodness, I was making it way too hard! Thanks that will help a lot.
The easiest option is probably to add a calculated column that compares the values in the two columns.
Fields Match = Table[Field1] = Table[Field2]
Then you can filer on that to = FALSE to find all those that don't match.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |