Hierarchy Question (3 Scenarios)

[imani_tech]

There are three scenarios:
1. The hierarchy does not change.

2. The data field does not change, but the parent of that data field’s hierarchy changes depending on the brand.

3. The data field itself can change. Therefore, there must be a different set of fields based on the brand and then create a hierarchy based on that.

I’m clueless about how to approach this an I appreciate any help whatsoever.

[v-huizhn-msft]

Hi @imani_tech,

Actually, I am confused about your three scenarios of Hierarchy. You create a Hierarchy in Power BI desktop and use it to drill down. More details, please review this vedio.

Best Regards,
Angelia