Flag stored as text instead of boolean
"Flag stored as text instead of boolean" is one of the modeling checks Auditabi runs on a Power BI semantic model. n column(s) whose name says flag, is… or has… are typed as text. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Normalise to a boolean in Power Query, or to a small set of documented values.
What is detected
n column(s) whose name says flag, is… or has… are typed as text. Each distinct spelling (Yes, YES, Y, 1) becomes a separate value, and filters miss rows.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Normalise to a boolean in Power Query, or to a small set of documented values.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.