Consider the Power BI model shown in the picture.
The Product Table has a relationship to the Product Category Table on the SKU column.
Here, you can check a sample of data inside the tables:
Product Table:
SKU: HD-001, Product: GymSmartwatch, Color: Blue
SKU: HD-002, Product: XSound Headphones, Color: Black
SKU: HD-003, Product: Laptop Pro 2000, Color: Green
Product Category Table:
SKU: HD-001, Category: Smartwatch
SKU: HD-002, Category: Headphone
SKU: HD-003, Category: Computer
You need to use in your Power BI report a Hierarchy that shows two levels: product and category.
Solution: From Power Query, merge the tables and then create the hierarchy.
Does this solution meet the goal?