Creating a Hierarchy from Multiple Tables

cjc322 in power bi desktop there is inline-hierarchy option but that only allows hierarchy from the current table. However if you have tables joined then you should be able to create drill down without any extra steps. All you need to do is select chart that supports drill down (column, bar etc) and put multiple fields from multiple tables (all joined) under Axis area.

You can also denormalize the fields into the table with the lowest granularity (assuming ITEM SKU).  This can be done on your SQL query (if using a query on a db) or iitem table (if other tables are all have relationships) by adding calculated columns to the item table....i.e.

SUBCLASS=RELATED( TABLE[SUBCLASS])

CLASS=RELATED( TABLE[CLASS])

DEPARTMENT=RELATED( TABLE[DEPARTMENT])

STORE=RELATED( TABLE[STORE])