Create hierarchy option not showing (tutorial)

[Mistborn]

I am trying to teach myself how to use Power BI Desktop and Power BI service by following this online tutorial. However, when I get to the 'Create Heirarchies' section, I cannot see this option in the Properties tab as the tutorial says I should. Any suggestions? Thanks!

[chris103]

For others coming to this thread, although it has been answered correctly, it is vague as to what caused the OP's problem.

The OP was clicking on the TABLE, that's why "Create Hierarchy" isn't showing.
You need to click on the COLUMN for it to show.

[Karthik_KJ]

https://community.fabric.microsoft.com/t5/Desktop/Hierarchy-not-available/td-p/1152897

[Greg_Deckler]

@Mistborn You need to right-click a column in the Data pane and then the top option should be Create hierarhy.

[Mistborn]

thanks Greg, but that's what I was doing and there doesn't seem to be 'Create Hierarchy' in the dropdown list.

[Anonymous · Accepted solution]

Hi @Mistborn , hello Greg_Deckler, thank you for your prompt reply!

Please check the following picture:

Additionally, you can download the sample PBIX file directly to study it.

powerbi-desktop-samples/AdventureWorks Sales Sample/AdventureWorks Sales.pbix at main · microsoft/po...

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mistborn]

Thanks, I can now see it in the drop down!