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

[Diana2022]

Hello,  I have a slicer for my business units.  The boolean logic is assigning "0" to GEN6 Weld so it does not appear in slicer.  I can't figure out why.   The data table is just a list of business units...and it is visible as a selection.  I've checked Selection pane and there are no hidden slicers or filters.  Any thoughts?   The business unit has data for the selected time period.  I cannot figure out what is prompting the "0" since its coming from a table in PowerQuery.

[Diana2022]

Thank you for your help... while data types were okay I did transform the column with "Trim" and "Clean".   This seemed to do the trick.   Your message prompted me to look harder at data and I am very appreciative.

[Anonymous · Accepted solution]

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.