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...
kemmerrc
Helper I
Helper IIs there a resolution to hierarchy issues with blanks. I have organizational levels from 1-12. Obviously, not all our groups go to a level 12. As stated in this chain, the hierarchy dropdown is useless. Is there a way to make it ignore blanks?