Creating Hierarchy and sub Hierarchy in desktop

[Monish2291]

Hi Team,

I need to create Hierarchy for measures and in that hierarchy i need to create sub-Hierarchy, i was able to create a single Hierarchy, but not able to create sub-hierarchy in that model. So i need help .

Thanks and Regards

Monish

[v-agajavelly]

Hi @Monish2291 ,

Just circling back to see if you had a chance to share the sample data we asked for. It’ll really help us get to the bottom of the issue and provide a more tailored solution. If you’re still stuck, feel free to drop the data and expected results whenever you can. And if things are sorted on your end, you can go ahead and mark the thread as resolved. Either way, we’re here to help.

Regards,
Akhil.

[v-agajavelly]

Hi @Monish2291 ,

Just checking in to see if you had a chance to share the sample data we requested earlier. This will help us better understand the issue and provide you with a more accurate solution. If you still need assistance, please provide the sample data and expected outcome as mentioned above. Otherwise, if everything’s resolved, feel free to mark the thread as solved. Looking forward to your response.

Best regards,
Akhil

[v-agajavelly]

Hi  @Monish2291 

We apologize for the inconvenience you are experiencing.
To assist you effectively, could you please share sample data that fully illustrates your issue or question? We kindly request that the data be provided in a usable format (rather than as a screenshot) and that it does not contain any sensitive information or unrelated content.

Additionally, it would be helpful if you could include the expected outcome based on the sample data you provided.

Thank you for your cooperation!

How to provide sample data in the Power BI Forum - Microsoft Fabric Community.

Regards,
Akhil

[v-agajavelly]

Hi @Monish2291 

Just checking,  Were you able to try out any of the suggestions shared earlier? If your issue is resolved, marking the accepted solution would be a big help to others who might be facing the same scenario.

If you went in a different direction or still need support, feel free to drop a quick update, we’re happy to keep helping.

Regards,
Akhil.

[Monish2291]

Hi Akhil,

No, that solution did not worked, trying out different solutions

Regards

Monish

[v-agajavelly]

Hi @Monish2291 

In Power BI, you're able to create a hierarchy using columns, but unfortunately, you can’t create a true "sub-hierarchy" within a hierarchy using measures directly. Power BI doesn’t support nesting measures inside a hierarchy structure like it does for columns.

If your goal is to group related measures (like Sales > Sales MTD, Sales YTD), the best way to handle that is using calculation groups with Tabular Editor. This lets you organize and simulate measure hierarchies — even include sub-levels by naming them in a structured way (like Sales | MTD, Sales | YTD).

Another option is to create a manual selector table that lets you choose from a list of grouped measures, and then use a DAX SWITCH to display the selected measure.

___________________________________________________________________________________________________________________________
 If my replies helped solve it, feel free to mark it as a solution so others can find it too. A quick “Kudos” is always appreciated as well.

Regards,
Akhil

[Monish2291]

Let me try and see what i can do, Thanks for your support

[Alex_Sawdo]

Do you mean a heirarchy as in a heirarchy of columns in the model or a heirarchy of measures in the data model? If you could share a screenshot of what you have currently, it will be easier to answer your question. 

[Monish2291]

Hi,

In the below screen shot i have created three hierarchy, now i want last 2 hierarchy to be part of Other Venue Hierarchy, this is the ask how can we achieve it,  please let me know if you have any idea. Thank You