How to determine what is evaluated in Boolean logic for Filter/Slicer- I'm missing a category

Hi Diana2022 ,

Here is my personal take on your question, and I think you can take the following steps:

1. Ensure that the data type for the "Business Unit" column in PowerQuery is set correctly. Sometimes, mismatched data types can cause unexpected behavior.

2. Verify the logic used in your PowerQuery transformations. If there's a step that assigns a "0" to GEN6 Weld, it might be due to a condition or calculation that needs adjustment.

3. Ensure that the relationships in your data model are correctly set up. Incorrect relationships can sometimes lead to data not appearing as expected.

4. Ensure there are no duplicate entries or conflicting data for the "Business Unit" column that might be causing the issue.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.