All checks
FormattingReliabilityMedium

Month or weekday name column without sort-by column

"Month or weekday name column without sort-by column" is one of the reliability checks Auditabi runs on a Power BI semantic model. n text column(s) hold month or weekday names without a sortByColumn. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Add a numeric MonthNumber / DayNumber column and set it as Sort by column.

What is detected

n text column(s) hold month or weekday names without a sortByColumn. Visuals sort them alphabetically (April, August, December…).

Why it matters

Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.

How to fix it

Add a numeric MonthNumber / DayNumber column and set it as Sort by column.

Reference

Tabular Editor BPA: Month (as a string) must be sorted

Does your model fail this check?

Free static audit with the exact objects, no account, nothing stored.

Audit a model

More Formatting checks