ModelModelingLow
Hierarchy whose levels look inverted
"Hierarchy whose levels look inverted" is one of the modeling checks Auditabi runs on a Power BI semantic model. n hierarchy(ies) list a finer level before a coarser one (month above year, city above country). It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Order the levels from the coarsest to the finest.
What is detected
n hierarchy(ies) list a finer level before a coarser one (month above year, city above country). Drilling down then goes up, and users lose trust in the hierarchy.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Order the levels from the coarsest to the finest.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.