Hierarchy blanks issue

When the hierarchy does not expand equally on all levels, it creates blanks. This is not the case with Excel or Tableau using the same data source (SSAS cube, live connection).  It makes Power BI unu...