Hi, as far as I know there’s no standard report that walks the category tree down to the items for you. The Item Category Code filter on the item list matches only the exact code, it doesn’t pull in the children. Quick workaround without any code, filter the Item List with a pipe, like ACCES|ACCES-01|01-TAPE|02-SEAL|03-CABLE, and save it as a view. On the Item Categories page you can also filter on Parent Category to see which codes sit under ACCES-01. For Power BI I’m not sure if the standard Inventory app shows the category hierarchy, I would check it before building anything. The pipe filter gets messy if the tree grows deep or changes often, then a small AL report is cleaner.
Glad to help - follow up if anything is unclear.
► If this solved it, marking it verified helps others too.
Regards,
Grigorios Mavrogeorgis
Business Central Consultant & AL Developer
Work: Gmsoft Limited
Blog: insidebusinesscentral
LinkedIn: linkedin.com/in/gregorymavrogeorgis